Given tables products(id, name), sales(product_id, quantity), write a query to find products with no sales and show their name and zero as quantity.
ASELECT p.name, COALESCE(s.quantity, 0) AS quantity FROM products p LEFT JOIN sales s ON p.id = s.product_id WHERE s.product_id IS NULL;
BSELECT p.name, s.quantity FROM products p INNER JOIN sales s ON p.id = s.product_id WHERE s.quantity = 0;
CSELECT p.name, 0 AS quantity FROM products p RIGHT JOIN sales s ON p.id = s.product_id WHERE p.id IS NULL;
DSELECT p.name, s.quantity FROM products p FULL JOIN sales s ON p.id = s.product_id WHERE s.product_id IS NULL;
