How many products in this table?
select count ( * ) from products
How many Product events in this table?
select count ( * ) from products_in_events
Show the names of products that are in at least 3 events?
select t1.product_name from products as t1 join products_in_events as t2 on t1.product_id = t2.product_id group by t1.product_name having count ( * ) > = 3
Find the top price?
select product_price from products order by product_price desc limit 1
find average of the price?
select avg ( product_price ) from products