What are the highest and lowest prices of products, grouped by and alphabetically ordered by product type?
select max ( product_price ), min ( product_price ) from products group by product_type_code order by product_type_code
What are the all product names
select product_name from products