need help with sql

Q1. MGS Exercise 1 [5 points) Write a SELECT statement that joins the Categories table to the Products table and returns these columns: category_name, product_name, list_price. Use aliases for the tables. Return only products having a category. Sort the result set by category_name and then by product_name in descending sequence. Q3. MGS Exercise 2 [ 5 points] Write a SELECT statement that joins the Customers table to the Orders table and returns these columns: first_name, last_name and the ship_amount. Include all customers even if they do not have any order. Suppress duplicates. Q5. MGS Exercise 3 (5 points] Write a SELECT statement that returns the product_id, product_name and discount_percent from the Products table. Return one row for each product that has the same discount_percent as another product. Q6. MGS Exercise 4 [5 points] Write a SELECT statement that returns the product_id, product_name and description of all products that have not been ordered