SELECT product_price FROM products WHERE product_id NOT IN (SELECT product_id FROM complaints)
What are the prices of products that have never gotten a complaint?
SELECT product_price FROM products WHERE product_id NOT IN ( SELECT product_id FROM complaints )
select product_price from products where product_id not in ( select product_id from complaints )
What are the prices of products that have never gotten a complaint ?