Question

Pick the correct select statement that groups on product_id, product_name, and calculates the average price. The grouped data must have at least an average price of $20.00.

Question 15 options:

	select product_id, product_name, avg(price) as average_price from products_sold group by product_id, product_name having price >= 20.00;
	select product_id, product_name, avg(price) as average_price from products_sold group by product_id, product_name having avg(price) >= 20.00;
	select product_id, product_name, avg(price) as average_price from products_sold where price >= 20.00 group by product_id, product_name;
	select product_id, product_name, avg(price) as average_price from products_sold where avg(price) >= 20.00 group by product_id, product_name;

Answer 1