Microsoft X B Assignment X Week #7 * Assignment X G Assignment X * Assignment * Assignment X coursehero X (294) I WILL X + c File C:/Users/Administrator/Downloads/Midterm%20Exam-W2021.pdf Week #7 2 / 4 100% + Le We are going to work with Adventurework2014 database. Therefore, open Adventurework2014 database as your default database. Do not forget to use the SQL standards. You can take a look at the database diagram (in the last page of the assignment). It will give you an idea of what we are going to work with. # 1 mark 5 Table Sales Customer Question How many rows are in the Sales.customer table (Name the column's title as 'Number of Sales'. How many unrepeated storelD's are in the table (Name the column's title as 'Number of Stores ? 2 6 Production Product Show all data in A) Production.Product with class = L, Production ProductCost History B) Production.ProductCost History with StandardCost less than 5 Purchasing Purchase Order Detail C) Purchasing.Purchase OrderDetail with OrderQty more than 5000. 3 15 Production Product Production ProductCost History In Adventurework2014 database we have several same columns in different tables. One of these columns is StandardCost. We can find it in Production ProductCost History and also in Production.Product tables. A) Which one is newer? Answer it by using a Join query to show modified dates and standard costs in both tables. B) Using a join query, show the difference in standard cost of the products which do not have the same standard cost. C) Find out the average changes in the standardcost. (Only Lone number must be returned) . 9 8:33 AM 3/5/2021 4 12 Production Product Purchasing Purchase Order Detail Concentrate on Purchasing. PurchaseOrder Detail and Production.Product Tables. We need a query to show all the product with seat Assembly' in their names which have not been purchased yet. (The ones without any values in their Purchase Order DetailID. 5 6 Purchasing Purchase Order Detail Use left join. Sort them by product ID. We need to know all the products with their StockedQty. Use group by and scalar function. Show only the productID and the total number. Sort them by the number of products from lowest to highest We need to create a new table and add all male employees 6 in the table. 6 Human Resources. Employee Table's name is Married MaleEmp and you have to copy all rows from Human Resources.Employee table. Do not forget to include only the male employees. SUM 50