All Notes on BCA

SELECT DISTINCT description, no_of_items_purchased as Total_Sold
FROM product_t5 p, cust_prod_t5 cp
WHERE EXISTS (SELECT * FROM Cust_prod_t5 WHERE cp.prod_no = p.pr
od_no);

DESCRIPTION          TOTAL_SOLD
-------------------- ----------
zzz                          60
xxx                          50
yyy                          50
xxx                          30
aaa                          10