# Exercise 2

1. Create a Database named `northwind`.
2. Download the SQL file from [this link](https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql) and run the code present in it inside the `northwind` database.\
   (Make sure that the tables are created inside `northwind` database only)
3. Write an SQL query to display the `ProductID`,  `ProductName`, `UnitPrice` from `Products` table in decreasing order of the `UnitPrice`.
4. Write an SQL query to display all the **distinct** `CategoryName` in `Categories` table.
5. Write an SQL query to **count** the total number of **unique** `OrderId` in `Order Details` table.
6. Write an SQL query to display the `OrderID`, `Employee Full Name` (example: Mr. John Doe), `Customer Company Name` and `OrderDate` in such a way that the Latest Order is displayed at the top.
7. Write an SQL query to display the **most expensive** `UnitPrice` in `Products` table for each `CategoryName`. Also, arrange it in ascending order of `CategoryName`.
8. Write an SQL query to display the `OrderID`, `CustomerName`, `OrderDate` and the `total sales amount` for each OrderId and Customer.\
   \&#xNAN;*(Total Sales Amount = (Quantity \* UnitPrice) - ((Quantity \* UnitPrice) \* Discount)*
9. Write an SQL query to display the `CustomerName` and the `total sales amount` for each OrderId and Customer.\
   \&#xNAN;*(Total Sales Amount = (Quantity \* UnitPrice) - ((Quantity \* UnitPrice) \* Discount)*
10. Write an SQL query to display the `SupplierName` and the `total sales amount` for each Supplier.\
    \&#xNAN;*(Total Sales Amount = (Quantity \* UnitPrice) - ((Quantity \* UnitPrice) \* Discount)*
11. Write an SQL query to display the `ShipperName` and the `Total number of orders` placed for each Shipper.
12. Write an SQL query to display the `CustomerName` and the `Total number of orders` placed for each Customer.
13. Write an SQL query to display the `ProductName` and the `Total number of orders` placed for each Product.
14. Write an SQL query to display the `ProductName` that has the most number of Orders Placed.
15. Write an SQL query to display the total Discount given out.
16. Write an SQL query to display `OrderId`, `CustomerName`, `OrderDate`, `OrderMonth` and `OrderYear` in increasing order of OrderDate.\
    \&#xNAN;*(Hint: use date time functions in SQL)*
17. Write an SQL query to display `Total Sales including discounts` for each `Month` and `Year`.
18. Write an SQL query to find the `month` with the most `number of orders` placed.
19. Write an SQL query to find the `year` with the most `number of orders` placed.
20. Write an SQL query to display the `TotalSales` for each `year`.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.consoleflare.com/t-sql-exercises/exercise-2.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.