Consider the SQL query:
SELECT productname
FROM product p
WHERE quantity > (SELECT SUM(quantity) FROM sales WHERE productid = p.productid);
What does this query aim to retrieve?
a) Product names with zero sales
b) Product names with a quantity greater than the total quantity sold
c) Product names with a quantity greater than the average quantity sold
d) Product names with a quantity greater than the total quantity available