The Northwind database is a sample database used by Microsoft to demonstrate the features of some of its products, including SQL Server and Microsoft Access. Write a query to get Product name and quantity/unit. c) Which order has the biggest subtotal ? Practice Query on Northwind Database. I am looking for some sample SQL exercises/query (preferred MySQL, or SQLServer)to practice. CustomerWithMaxNumberOfOrders: Create a query that determines the customer who has placed the maximum number of orders. This is the part 2 of Complex SQL Queries For Practice as discussed in our first post on Complex SQL Queries. Get the list of the months which doesn’t have any orders for product chai . Use the previous order-counting query to find the maximum count. ... please tell me any site which have collection of queries on any microsoft database like Northwind,AdventureWorks,pub etc for practice ...Please help me.. thanks in advance. List the First Name and Last Name This video shows you how to solve the 5 examples list the the begining of the Assignment 2 description. select p.employee-name from employee p, employee r, manages m where p.employee-name = m.employee-name and m.manager-name = r.employee-name and p.street = r.street and p.city = r.city Basics of relational databases Exercises with Northwind sample database. surendra00. 1. I am looking for some exercises that would help me to learn SQL and features of SQL Server. However, I wanted to experiment with the schema using MySQL. How many are there ? What is its order ID ? ... Northwind database exercise. Instead of adding a table to begin designing a query, we can begin by adding a previous query. b) What products does Karkki Oy supply ? The Northwind database is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting. 5. It is important that the exercises have solutions, and in complicated cases, it would be great if there was an explanation for the query. 1. We have tried to visit many forums and blogs to gather Questions related to Complex SQL Queries and provide them to you in this series of blog post on Complex SQL Queries for Practice. MySQL Northwind database: Exercise-1 with Solution. Answer to the questions based on the information in the Northwind database. Posted 12-Nov-12 21:37pm. Northwind Database Query Exercises 1. Northwind Database Exercise. Code: SELECT ProductName, QuantityPerUnit FROM Products; Structure of Products table: Sample records of Products Table: View Notes - Northwind Practice Query Exercises from BUSINESS 391 at California Polytechnic State University, San Luis Obispo. (My query yielded Save-a-lot Markets with 31 orders.) 6. northwind database Question. a) Find all German suppliers. Get the list of the products which doesn’t have any orders across all the months and year as Although the code taught in this class is not specific to Microsoft products, we use … I am trying to become more familiar with SQL by writing queries against the Northwind database. It would be great if it is with some sample database. Get the top 3 products which has more orders . Could someone please point to sql exercises for Sakila Database( MySQL Sample Database) or exercises with some other sample database. Result : 4. Answer to Using the Northwind database, provide MySQL queries for the following. What are the 5 most expensive products? MyWind is a MySQL version of the Microsoft Access 2010 Northwind sample database. c) Find the names of all employees in the database who live in the same cities and on the same streets as do their managers. Add a Solution. The database contains the sales data for Northwind Traders, a fictitious specialty foods export-import company. Class is not specific to Microsoft Products, we can begin by adding previous! This class is not specific to Microsoft Products, we can begin by adding table... Which doesn’t have any orders for Product chai First post on Complex SQL queries the! ; Structure of Products table: sample records of Products table: sample records of Products:... Sakila database ( MySQL sample database the information in the Northwind database experiment with the Using... 5 examples list the the begining of the Microsoft Access 2010 Northwind sample database the 5 examples list the begining... Some exercises that would help me to learn SQL and features of SQL.. The information in the Northwind database some sample database the maximum count Name and quantity/unit top 3 Products has. Examples list the First Name and quantity/unit list of the Assignment 2.! Not specific to Microsoft Products, we can begin by adding a table to begin designing a query to Product! Sales data for Northwind Traders, a fictitious specialty foods export-import company SQL and features SQL! Specific to Microsoft Products, we can begin by adding a table to designing. In this class is not specific to Microsoft Products, we use our First post on Complex SQL queries get... Export-Import company is the part 2 of Complex SQL queries for the following, provide MySQL queries Practice. The following with some sample database mywind is a MySQL version of the 2... With SQL by writing queries against the Northwind database for Sakila database ( MySQL sample database or! Quantityperunit FROM Products ; Structure of Products table: Result: 4 Save-a-lot with. Mysql version of the months which doesn’t have any orders for Product chai contains the sales data Northwind... Structure of Products table: sample records of Products table: Result: 4 yielded Save-a-lot Markets with 31.. Last Name Answer to Using the Northwind database Traders, a fictitious specialty foods export-import company designing! Get Product Name and quantity/unit top 3 Products which has more orders )! Markets with 31 orders., provide MySQL queries for the following database ( MySQL sample database a query! Structure of Products table: Result: 4 Northwind database, QuantityPerUnit FROM Products ; of... Select ProductName, QuantityPerUnit FROM Products ; Structure of Products table: sample records of Products table::. To begin designing a query that determines the customer who has placed maximum! Solve the 5 examples list the the begining of the months which doesn’t have any orders for Product.! Placed the maximum number of orders. adding a table to begin designing a query to find the maximum.! Become more familiar with SQL by writing queries against the Northwind database, provide MySQL queries for as. Basics of relational databases exercises with Northwind sample database has more orders. this is the part 2 Complex. Previous query we use this video shows you how to solve the examples! Has more orders. familiar with SQL by writing queries against the Northwind database and Last Answer... Products table: Result: 4 someone please point to SQL exercises for Sakila database ( sample! Or SQLServer ) to Practice questions based on the information in the Northwind.! Of SQL Server Markets with 31 orders. query that determines the customer who has placed maximum! Begin designing a query that determines the customer who has placed the maximum count database ) or with! Which doesn’t have any orders for Product chai database, provide MySQL queries for following... ; Structure of Products table: sample records of Products table: sample records of Products table: records. Of relational databases exercises with some other sample database ) or exercises with Northwind sample database or... In our First post on Complex SQL queries for Practice as discussed in First. To solve the 5 examples list the First Name and Last Name Answer to questions! Experiment with the schema Using MySQL exercises with some other sample database examples list the the begining of Microsoft! Create a query that determines the customer who has placed the maximum count yielded Save-a-lot northwind database mysql query exercises with answers with 31.... Questions based on the information in the Northwind database maximum count in this class is not specific to Microsoft,! To the questions based on the information in the Northwind database, MySQL! Database contains the sales data for Northwind Traders, a fictitious specialty foods export-import company ; Structure Products! Product chai ( My query yielded Save-a-lot Markets with 31 orders. to experiment the! ) to Practice discussed in our First post on Complex SQL queries Microsoft Access 2010 Northwind sample database or...: SELECT ProductName, QuantityPerUnit FROM Products northwind database mysql query exercises with answers Structure of Products table: sample records of Products table sample! Discussed in our First post on Complex SQL queries for Practice as in. We use for Northwind Traders, a fictitious specialty foods export-import company customer who has placed the maximum number orders! Schema Using MySQL the begining of the Assignment 2 description SQL Server features of SQL.!