What would the queries be? For the below question:

Lab 9: SQL DML Query in MySQLSQL Query from Multiple TablesIS 4420, Database FundamentalsWe importthe four tables using the same customer_order.sql script. Open a lab9.txt text file to hold your working SQL statements. Once you have ensured that a particular SQL statement below is working, paste it into this text file. DML: query 1.Do a Cartesian Product from all four tables (Customer, Product, Orders, Orderline). (20400 rows)2.List customer information for customers that have placed orders after 2008-10-27 (Use Equi Join). (3 rows) 3.List unique customer information for all customers who have orders, from SLC and whose first name starting with a letter J (Use Inner Join). (3rows)4.List unique product name, product price and product price after 10% discount of all products that exist in orderline (Use natural join). (8 rows)5.List product information for those products in as well as not in orderline with price higher than 100 (Use Left join where product is the left table). (3 rows)6.List name and price for all products that have been purchased in order 1001 (Use subquery IN). (3 rows)7.List customer names who ordered Apple Laptop (Choose your own join type). 8.Show the average price of products bought by customers from Tucson. 9.List total dollar amount ordered for each order, (use sum(product_price * quantity))(Need to join orderline and product tables). 10.List all product names with respective orderline item counts for products with more than 2 counts. IV. Deliverables Submit the lab9.txt file that contains your SQL statements to canvas. Do not submit your query results, just your SQL queries.