Products Never Sold
products has columns product_id and name. sales has a column product_id (one row per sale). Return the names of products that never appear in sales, in the order of products.
Example 1
products {"product_id":[1,2,3],"name":["pen","cup","pad"]}
sales {"product_id":[1,1,3]}
returns ["cup"]
cup was never sold.
Constraints
- The result may be an empty list
Write it in your browser, against the clock. The model solution, stepped through line by line, comes after.