Database SQL Analyser: NorthWinds Database[Back] [Database] [SQL Test] This page shows the NorthWinds database: |
Tutorial
- Find customers in Mexico Solution
- Find customers in US or UK Solution
- Find the number of customers in US or UK Solution
- Find the number of customers in the database Solution
- Find orders where France is the shipping country Solution
- Find orders where it freight weights over 40 Solution
- Find suppliers who in the UK but not in London Solution
- Find customers who's company name begins with A Solution
- Find the number of customers who's company name begins with B Solution
- What is the name of product 18? Solution
- What is the name of products with an ID greater than 10? Solution
- How were hired after Jan 17, 1993? Solution
- The products for product ID of 4 (Dairy Products) which have less than 10 units left? Solution
- Order products by unit price (ID, Price, and Product Name) Solution
- Order products by unit price (ID, Price, and Product Name) - highest first Solution
- Order products by unit price (ID, Price, and Product Name) with each category Solution
- Show the number of condiments as MyCondiments for Category ID of 2 Solution
SQL Commands used
- SELECT * FROM Categories Try
- SELECT * FROM Customers Try
- SELECT * FROM [Order Details] Try
- SELECT * FROM Employees Try
- SELECT * FROM Orders Try
- SELECT * FROM Products Try
- SELECT * FROM Shippers Try
- SELECT * FROM Suppliers Try
- SELECT LastName, FirstName FROM Employees ORDER BY LastName Try
Other examples
- Products for Order 10249 Try
- Display most recent order Try
- Show order and total Try
- - For orders greater than $1000 Try
- Number of order lines than make an order Try
- - With more than three orders Try
- Number of order lines for product ID 2 (Chang) and 3 (Aniseed Syrup) Try
- - with more than three orders Try
- Order ID and product name for each order line on the Order Details table Try
- Orders (order ID, customer ID, and order date, sales rep first name) for the sales rep for their order for September 1994 Try
- Category Sales for 1995 Try
- Current Product List Try
- Create a new table Try and view the table Try
- Employees, order IDs and order dates, for employees between September 26 through September 30, 1994 Try
- Employees, order IDs and order dates, for employees between September 26 through September 30, 1994 with no orders Try
- Employee (ID, last name, and first name) and Employee's supervisor (first and last name) Try
- - even if they do not have a supervisor Try
- Employees (first name and last name) that either placed orders on the week of September 26 through September 30, 1994, or employees that ever had an order containing a Chef Anton product (product IDs 4 or 5), or both Try
Database