Can you please

Open the attachment 

To get the Question 

I'm going to upload the helping files

 

Relational Database Management (X414.51)Week 10 SQL AssignmentName: ____________________________________Download, unzip, and attach (to SQL Server) the sample Northwind Traders SQL Server databasefound in the Week 10 module area. Write the needed SQL for each of the following situations andupload your completed document when done for grading.1.Write the needed SQL to list all product names (and only product names) from the Productstable that fall into the category of “condiments.” The list of products should be in ascendingorder.2.Write the needed SQL to update the description of the “Produce” category from “Dried fruitand bean curd” to “Dried fruit, bean curd, and soy.”3.Write the needed SQL to produce a list that will contain the following columns:OrderID, OrderDate, RequiredDate, ShippedDate, Quantity, UnitPrice, ProductNameThe list should contain only the orders that were placed in April 1997 (the entire month). Thelist should be in ascending order by OrderDate and then Quantity.4.Write the needed SQL to update all suppliers in Germany that do not have a fax number bysetting their fax number to ‘N/A.’5.Write the needed SQL to produce a list with the following columns.CustomerID, CompanyName, OrderID, OrderDate, Order Item CountThe list will contain (as the last column) the total number of order items per order. Displaythe results in ascending order by company name and order id. Here is an example:6.Write the needed SQL to delete all order information for customer “QUICK-Stop.”

Attachments:

• 1494311073-Week_10_SQLAssignment.doc