Products nobody has bought yet
GCash's merchant marketplace team wants to clean up the product catalog — starting with items that have never actually sold, so they can chase the merchant or delist them.
From gcash_products and gcash_orders, return the product_id and product_name of every product that has zero rows in gcash_orders. Order the output by product_id.
Schema
▸gcash_products
| product_id | INT |
| product_name | TEXT |
▸gcash_orders
| order_id | INT |
| product_id | INT |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime