Wanted Statuses
orders has columns id and status (text). wanted is a list of statuses. Return the ids of orders whose status is in wanted, in the order they appear.
Example 1
orders {"id":[1,2,3],"status":["new","paid","lost"]}
wanted ["paid","lost"]
returns [2,3]
Orders 2 and 3 match.
Constraints
wantedmay be empty
Write it in your browser, against the clock. The model solution, stepped through line by line, comes after.