Question $8$

$10pts$

Find the items sold by at least two times by the departments on the second floor. Show the item names and the number of sales made for those items.

SELECT A$4$SALE.ITEMNAME, $(*)$ as "Number of sales"

FROM A$4$SALE, $$

WHERE A$4$SALE, $$

$$ AND

DEPTFLOOR $=2$

$$ A$4$SALE

${(}^{**})>$