please ans this qsn within 10 min

Execute the data.sql file. The sql file contains the necessary DDL statements to create and store values inside the table. The table is as follows: SALESMAN (Salesman_id, Name, City, Commission) CUSTOMER (Customer_id, Cust_Name, City, Grade, Salesman_id) ORDERS (Ord_No, Purchase_Amt, Ord_Date, Customer_id, Salesman_id) Write SQL queries to 1. Insert a new customer with your name and city. 2. Show the total number of orders and purchase amount done by each Customer 3. Find the total number of customers that obtained the grades above CHENNAI average. 4. Find out the name and numbers of all salesmens who had more than one customer. 5. List all salesmen and indicate those who have and dont have customers in their cities 6. Create a view that finds the salesman who has the customer with the highest order of a day. 7. Remove the salesman with id 1000 along with his All orders. 8. Find out the customer ID who has given multiple orders in the same day.