Using the schema diagram below, have to develop TSQL script for each question. Use JOIN wherever applicable (do not use EXISTS!). Do NOT use variable or temporary table. <img src="/uploads/sqlteam/original/1X/8de7f3237885b2701e3dffe5268cfc1449ebf70a.png" width="573" height="154">
Note: CustomerName is also involved in Customer Table
1. List the top 10 customers for the current year by total sales. Column List: CustomerName, [Total Sales] Sorting Order: [Total Sales] (desc) 2. List the customers with the total sales, who placed an order last year but not this year. Column List: CustomerName, [Total Sales] Sorting Order: [Total Sales] (desc) 3. List last year’s 10 best-selling products and 10 least-selling products with the total sales. Column List: ProductName, ProductNumber, [Total Sales] Sorting Order: [Total Sales] (desc) 4. Reduce Product’s ListPrice by 20% if it did not receive any order for the last two years and the reduced price would be still above StandardCost. - Update ListPrice in Product.