Show the names of products that are in at least two events in ascending alphabetical order of product name.
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 ( * ) > = 2 order by t1.product_name
What is the product price of men suits?
select product_price from products where product_name = "Men suits"
What is the most expensive product price?
select max ( product_price ) from products
How about the least expensive?
select min ( product_price ) from products
Yes
select product_type_code from products order by product_price limit 1