For each product that has more than three items sold within all sales transactions, retrieve the product id, product name, and product price. Query 30: SELECT productid, productname, productprice FROM product WHERE productid IN (SELECT productid FROM includes GROUP BY productid HAVING SUM(quantity) > 3); duce. Query 31 text: For each product whose items were sold in more than one sales transaction, retrieve the product id, product name, and product price. Query 31: SELECT productid, productname, productprice FROM product WHERE productid IN (SELECT productid FROM includes GROUP BY productid HAVING COUNT
