adventureworks database query exercises pdf

ADVENTUREWORKS DATABASE QUERY EXERCISES PDF UPDATE

What is the total amount each customer has payed us so far (Hint: QUICK-Stop has payed us.

What were our total revenues in 1997 (Result must be 617.085,27).Delete the records you inserted before.

ADVENTUREWORKS DATABASE QUERY EXERCISES PDF UPDATE

Repeat previous update but this time update all orders associated with you (1 row).

Double the quantity of the order details record you inserted before (1 row).

Update the phone of yourself (from the previous entry in Employees table) (1 row).

Include the following fields: OrderID, ProductID, UnitPrice, Quantity, Discount

Insert order details in the Order_Details table.

Include the following fields: CustomerID, EmployeeID, OrderDate, RequiredDate

Insert an order for yourself in the Orders table.

Include the following fields: LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, City, Region, PostalCode, Country, HomePhone, ReportsTo

Insert yourself into the Employees table.

The report should only return rows for which the total number of orders is greater

Create a report that shows the total number of orders by Customer since December 31,1996.Only show records for products for which the quantity ordered is fewer than 200 ( 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

Adventureworks database query exercises pdf