Need help writing SQL queries for #5-8. Database info is listed, thanks.

the product line name and the number of products included in the product line. Also give the number of products the alias of NoofProducts. Hint: You need to include 2 tables in your FROM clause and you need 1JOIN. Each product line has a unique name. Use an aggregating function (COUNT) to calculate the number of products in each product line. Then, you will need to specify criteria that only product lines with two or more products will be included. Use HAVING to specify criteria for a group. 6. Write a query using LEFT OUTER JOIN that will retrieve customer ID, customer name, and order date, and that will display customer data even if the customer has not placed an order. Hint: See page 181 of textbook for an example. In SQLite, RIGHT OUTER JOIN and FULL OUTER JOIN are not supported. 7. Write a nested query that will retrieve the productid, product description, and product price for each product whose price is greater than the average price of all products. Hint: see page 160 of the textbook for an example. 8. Now write a nested query that will list the customer name for orders that were placed before 2022-11-09. Customer Order t Productline Orderline Product