What is the name of the products?
select product_name from products
What is the highest price for the products?
select max ( product_price ) from products
What product has been ordered the greatest number of times?
select t1.product_name from products as t1 join regular_order_products as t2 on t1.product_id = t2.product_id group by t2.product_id order by count ( * ) desc limit 1
What is the price of the dvds?
select product_price from products where product_name = 'dvds'