Create a report that shows the total quantity of products (from the Order_Details table).Shipped after the required date (37 rows) Create a report that shows the order ids and the associated employee names for orders that.Create a report that shows the number of employees and customers from each city (.Create a report that shows the number of employees and customers from each city that has.Create a report for all the orders of 1996 and their Customers (152 rows).Using the Northwind Database, write the queries for the following: Get all orders placed on the 19th of May, 1997. Get the names of all the contact persons where the person is a manager, alphabetically.Get the count of all Orders made during 1997.Get all Customers alphabetically, by Country and name.Get all columns from the tables Customers, Orders and Suppliers.Querying the database – Part 2 Questions Answers.Querying the database – Part 1 Questions Answers.3 sets of Sql exercises on Northwind Database
0 Comments
Leave a Reply. |