Northwind Database Sql Queries

c Ê 0001000200030002000400050006000700050002 000e00020006000f001000060011000200120004000b0013001400050013 000f00060015 000e00060005001600020006000700050002 0013000200120006000500170003000200060012 00050002001000060017 0006000700050002 000e0002 00060006 0018 Ê 00010002000300020004000500060007 000f000500040005 000e0002001900060007 000e0014000f 000e0002001900060007 000f000500040005001a001300050003000200190006000f00100006001b0016 000f000200060015 000e000600050016000200060007001c00120005 000e0002000b00120006000500170003000200060012 00050002001000060017 0006 001b0016 000f0002 00060006 001d Ê 0007000b00020005000200060006000b00020014 0005000600120016 001e0013000f 00060002000e00140003 000200020012001f000600150013000b001200050006000f001000060003001200050006000f000e000200120006000f0010000600160013000b00020006001000050002001200060012 00050002001000060015 000e0006000f0002001e00020012000500060005 0006 000300100002001200050006 0002000e00140003 00020002 00060006 Ê 0007000b00020005000200060006000b00020014 0005000600120016 001e0013000f 0006 00050016001e0013000f0010001f00120006 00100002000b001200060012 00050002001000060017 0006!000b00020013 0016000500060015 000e0006000e 0012000500060002'00140002000f00120013#000200060005 00060004001600020014000200120005 0006 00010016 001e0006$000b00100002000b%001100190006$000b00100002000b001100050002001900060001001600130014001400020010001100050002001900060007001c00120005 000e0002000b%001100190006000f00100006!000b00020013 00160005 00060006 & Ê 00010002000300020004000500060007 000e0014000f 000e000200190006!'00190006001b0016 000f000200190006' 000e0002001b 00020006000f001000060007 001c000f0005 00060015 000e000600050016000200060001001c00140014000300130002000b00120006000500170003000200060012 00050002001000060017 0006 0007 001c000f0005 00060013000f000600100002001200040002000f00100013000f 0006 00100002000b0006000f00100006000500160002000f00060017 00060007 000e0014000f 000e000200060013000f0006001200040002000f00100013000f 0006 00100002 0006 ( Ê 0007000b00020005000200060006000b00020014 0005000600120016 001e0013000f 000600030003000600050016000200060004 000e0014000f 0006000f000e000200120006000f001000060004 000f0005000400050006000f000e000200120006 00150006 00050016001e0013000f0010001f001200060004001c00120005 000e0002000b001200060013000f0006 )001c0002000f 00120006*0013000b00020012 00060006 + Ê 0007000b00020005000200060006000b00020014 0005000600120016 001e0013000f 000600050016000200060014 0010001c000400050006000f000e000200190006001c000f0013000500060014000b0013000400020006000f00100006,001c000f000500130005 000600140002000b0006001c000f001300050006 001500060003000300060014 0010001c00040005001200060005001600050006000b00020006 001c00050006
0015000600120005 0004- 00060006 . Ê 0007000b00020005000200060006000b00020014 0005000600120016 001e0013000f 00060005001600020006 00100002000b00060010000500020019000600120016001300140014000200100006001000050002001900060004001c00120005 000e0002000b00060013001000190006000f001000060015000b00020013 001600050006 00150006000300030006 00100002000b00120006001400030004000200100006 000f0006 / 0006c000190006c00+ 00060006 0 Ê 0007000b00020005000200060006000b00020014 0005000600120016 001e0013000f 0006000500160002000600150013000b001200050006000f000e0002001900060003001200050006000f000e000200190006000f001000060004 001c000f0005 0006 001500060003000300060002000e00140003 0002000200120006000f 000500060013000f000600050016000200061000f00130005000200100006 00010005000500020012 0006 c2 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060002000e00140003 0002000200060013001000190006 00100002000b000600130010001900060004001c00120005 000e0002000b00060013001000190006000b0002,001c0013000b00020010000600100005000200190006000f00100006001200160013001400140002001000060010000500020006 00150006 000300030006 00100002000b001200060005001600050006001e0002000b0002000600120016001300140014000200100006000300050002000b000600050016000f0006000500160002 0006001e0002000b00020006000b0002,001c0013000b00020010 0006 cc Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060005001600020006000400130005 001900060004 000e0014000f 0006000f000e000200190006000f001000060004 000f0005000400050006000f000e00020006 001500060003000300060004001c00120005 000e0002000b00120006001e0016 0006000b000200060013000f0006 0004001300050013000200120006000500160005000600170002 0013000f0006001e00130005001600063*30006 00063) 30006 c0018 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e00120006000300030006 00100002000b0012000600050016000500060016#0002000600060015000b00020013 0016000500060004 001200050006 00150006000e 0002000600050016000f00064&22 22 0006 c001d Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060014 0010001c000400050006000f000e000200190006001c000f00130005001200060013000f000600120005 0004-00190006001c000f0013000500120006 000f0006 00100002000b00190006000f00100006000b0002 00100002000b000600030002#000200030006 00150006000300030006 0014 0010001c00040005001200060005001600050006000b00020006001c001400060015 0006000b0002 00100002000b0006 c Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060004 000e0014000f 0006000f000e0002001900060004 000f0005000400050006000f000e00020006000f001000060015'0006000f001c000e00170002000b0006 001500060003000300060004001c00120005 000e0002000b001200060005001600050006 0016#0002000600060015'0006000f001c000e00170002 0006 c& Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e00120006000500160002000600150013000b001200050006000f001000060003001200050006000f000e00020006 001500060003000300060002000e00140003 0002000200120006001e0016 00060010 0006000f 00050006000b00020014 000500060005 0006000f 0017 0010 0006 c( Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060004 000e0014000f 0006000f000e0002001900060004 000f0005000400050006000f000e00020006000f001000060015'0006000f001c000e00170002000b0006 001500060003000300060004001c00120005 000e0002000b001200060005001600050006 0016#0002000600060015'0006000f001c000e00170002 00060001 000500060017 00060004 000e0014000f 0006000f000e0002 0006 c+ Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060005001600020006000400130005 001900060004 000e0014000f 0006000f000e000200190006000f001000060004 000f0005000400050006000f000e00020006 001500060003000300060004001c00120005 000e0002000b00120006001e0016 0006000b000200060013000f0006 0004001300050013000200120006000500160005000600170002 0013000f0006001e00130005001600063*30006 00063) 300060001 000500060017 00060004 000f0005000400050006000f000e000200060013000f000600100002001200040002000f00100013000f 0006 00100002000b0006 c. Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e00120006000500160002000600150013000b001200050006000f001000060003001200050006000f000e000200120006000f0010000600170013000b0005001600060010000500020006 001500060003000300060002000e00140003 00020002001200060017 000f00060013000f00060005001600020006c0&20012 0006 c0 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060014 0010001c000400050006000f000e00020006000f001000060012001c00140014000300130002000b00060013001000060015 00060003000300060014 0010001c00040005001200060012001c00140014000300130002001000060017 00065' 0005001300040006 60013,001c001300100012001900067000b000f0010000e00068000200030003 001f00120006' 000e0002001200050002001000190006000f00100006001a - 0006001a000b00100002000b0012 0006ð 00010002[0006 001c0006001e0013000300030006000f00020002001000060005 000600150013000b0012000500060010 00060006001200020014000b000500020006 00015650007001a0006 000f000600050016000200060001001c00140014000300130002000b00120006000500170003000200060005 000600150013000f0010000600050016000200060012001c00140014000300130002000b00060013001000120006 0015000600050016000200120002000600050016000b0002000200060004 000e0014000f001300020012 0006 00182 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060005001600020006001200160013001400140013000f 00060014 00120005000300060004 0010000200190006 00100002000b00060013001000190006000f00100006 00100002000b000600100005000200060015 0006000300030006 00100002000b00120006001e0013000500160006000600120016001300140006 0014 00120005000300060004 00100002000600170002 0013000f000f0013000f 0006001e0013000500160006320018001d.03 0006 0018c Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060004 000f0005000400050006000f000e00020006000f00100006000500130005000300020006000f0010000600050016000200060004 000e0014000f 0006000f000e000200060015 00060003000300060004001c00120005 000e0002000b00120006001e0016 001200020006 0004 000f00050004000500060005001300050003000200060010 000200120006000f 000500060004 000f00050013000f00060005001600020006001e 00100006300010003000200123 0006 00180018 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e00120006000500160002000600150013000b001200050006000f001000060003001200050006000f000e000200120006000f001000060004001300050013000200120006 001500060002000e00140003 00020002001200060015 000e00060004001300050013000200120006 000500160002000b000600050016000f0006 00010002000500050003000200060013000f0006000500160002000600120005000500020006 001500069001200160013000f 0005 000f 0006 0018001d Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060004 000e0014000f 0006000f000e0002001900060004 000f00050004000500060005001300050003000200190006000400130005 0006000f001000060004 001c000f0005 0006 001500060003000300060004001c00120005 000e0002000b001200060013000f0006 /0002'00130004 0006 00060013000f0006000f 0006000400130005 00060013000f0006000100140013000f00060002'00040002001400050006/0010000b00130010 0006 0018 Êr 000100020003000400050004000600070007 0004000b0002000500020003 0003 000200040002000e000500020004000f00100002001100100002000b00040002000e000300040012000f00130013000f00140001 001500160006
0006
0018& Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060005001600020006001c000f00130005001200060013000f000600120005 0004-00190006001c000f0013000500060014000b0013000400020019000600050016000200060005 0005000300060014000b0013000400020006#0003001c00020006 00150006000300030006001c000f00130005001200060013000f000600120005 0004-001900060005001600020006 0005 0005000300060014000b0013000400020006#0003001c00020006 00150006000300030006001c000f00130005001200060013000f000600120005 0004-0006 001c000f00100002001000060010 001e000f00190006000f0010000600050016000200060005 0005000300060014000b0013000400020006#0003001c00020006 00150006000300030006001c000f00130005001200060013000f000600120005 0004-0006 001c000f0010000200100006001c0014 00060001 000500060017 000600050016000200060005 0005000300060014000b0013000400020006#0003001c0002000600100002001200040002000f00100013000f 0006 0018( Ê0001:6000600015;<5;0006* 00110006/=0001:60006100015;00010006$ 6=[0006%000f0006000f00060002000b000300130002000b000600100002000e 00190006 001c00060012001e00060006000b00020014 000500060005001600050006000b00020005001c000b000f0002001000060005001600020006 00020006 0015000600020004001600060002000e00140003 000200020006001e00160002000f000600160013000b00020010 0006001a001600050006000b00020014 00050006001e00120006000f 000500060002000f00050013000b00020003 000600040004001c000b00050002000600120006001300050006001000130010000f001f0005000600040004 001c000f000500060015 00060005001600020006 000e 000f000500160006000f001000060010 000600050016000200060002000e00140003 000200020006001e001200060017 000f 0006!0013'00060005001600050006000b00020014 00050019000600120016 001e0013000f 00060017 0005001600060005001600020006 0013 0013000f00030006>0013000f00040004001c000b00050002?000600160013000b00020006 00020006000f00100006000500160002000600040005001c0003000600160013000b00020006 0002 0006001a001600020006000b00020012001c000300050006001e00130003000300060003
-000600030013-000200060005001600130012 00060006
0006 0018+ Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e00120006000500160002000600150013000b001200050006000f001000060003001200050006000f000e000200120006000f0010000600170013000b000500160006000e 000f000500160006>00120006000600120005000b0013000f ?00060015 000600020004001600060002000e00140003 000200020006 0017 000f00060013000f000600050016000200060004001c 0002000f00050006000e 000f00050016 0006 0018. Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e0012000600050016000200060004 000f00050004000500060005001300050003000200060013000f00060003000300060003 001e0002000b000400120002000600030002000500050002000b00120006 0015000600020004001600060004001c00120005 000e0002000b00060004 000f000500040005 0006 00180 Ê 000e0003000400050017000f001800030004000600070007 0004000b0002000500020003 0003 0002000400140001001300130004 000300020010 00040002000e000300040012000f00130013000f00140001 00150004 0003000b001000130002000b0006
0006 001d2 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060003000300060014 0010001c00040005001200060017 0006000f000e000200060005001600050006000b000200060013000f00060005001600020006000100020015
00100006000400050002 0006 001dc Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060003000300060004 000e0014000f00130002001200060017 0006000f000e000200060005001600050006001200020003000300060014 0010001c00040005001200060013000f0006000700050002 %00110006. 0006 001d0018 Ê0007000b00020005000200060006000b00020014 00050006000500160005000600120016 001e001200060003000300060004 000e0014000f00130002001200060017 0006000f000e000200060005001600050006001200020003000300060014 0010001c00040005001200060013000f00060005001600020006000100020015
00100006000400050002 0006 001d001d Ê 0003000500020003000400050004 00030011000f 000200040002000e000500020004000b000e000f0014000b00040002000e00030004000f 00190003 000400010019000b00040005 001900040002000e000300040005 000f001a0001000500020003001900040003 00110013000f001b000300030004 0005 0003000b00040012000f 0004000f 00190003 00040002000e000500020004000b000e0001001100110003001900040005001200020003 0004 0002000e00030004 0003001c00100001 000300190004001900050002000300160004001d00020004000b000e000f0010001300190004 000300020010 00040002000e000300040012000f00130013000f00140001 001500160004 000e0003 00030004000b000e000f0010001300190004001700030004001e001f0004 000f0014000b0004 000300020010 0003001900160006
0006 001d Ê 0003000500020003000400050004 00030011000f 000200040002000e000500020004000b000e000f0014000b00040002000e000300040002000f0002000500130004001c00100005 000200010002001b0004000f001200040011 000f00190010001a0002000b0004 0012 000f 00040002000e00030004! 00190003 '#00030002000500010013000b000400020005001700130003$0004000f 00190003 0003001900160004! 0013001b0004000b000e000f00140004 0003001a000f 0019000b00040012000f 00040011 000f00190010001a0002000b00040012000f 00040014000e0001001a000e00040002000e00030004001c00100005 000200010002001b0004000f 00190003 0003001900040001000b00040012000300140003 00040002000e0005 0004%&&00160004 000e00030004 00030011000f 00020004000b000e000f0010001300190004 000300020010 00040002000e00030004 0012000f00130013000f00140001 00150004'0004 000f0014000b00160006
0006 0006 001d& Ê 0003000500020003000400050004 00030011000f 000200040002000e000500020004000b000e000f0014000b00040002000e000300040002000f0002000500130004 0010 00170003 0004000f00120004000f 00190003 00040017001b0004 0010000b0002000f 0003 0004000b0001 001a00030004#0003001a0003 00170003 0004001e()0004(**+00160004 000e00030004 00030011000f 00020004 000e000f0010001300190004000f 0013001b0004 000300020010 0004 000f0014000b00040012000f 00040014000e0001001a000e00040002000e00030004,0010 ! 00190003 00040001000b00040015 0003000500020003 00040002000e0005 0004('00160004 000e00030004 00030011000f 00020004000b000e000f0010001300190004 000300020010 00040002000e000300040012000f00130013000f00140001 00150004 '0004 000f0014000b00160006
0006 0006 001d( Ê 0003000500020003000400050004 00030011000f 000200040002000e000500020004000b000e000f0014000b00040002000e00030004001a000f 00110005 001b0004 0005 0003)0004000f 00190003 000400010019)00040005 001900040002000f00020005001300040011 0001001a00030004000f0012000400050013001300040011 000f00190010001a0002000b0004000f001200040014000e0001001a000e0004,000f 0002000e00140001 00190004 000e0005000b0004000b000f001300190004 000f 000300040002000e0005 0004-(&)&&&00040014000f 0002000e00160004 000e0003 000300040001000b0004 000f0004 00030003001900040012000f 000400050004./!010004230004001a001300050010000b000300040001 00040002000e0001000b0004 00030011000f 000200160006
0006
Northwind Database Sql Queries

Sql Database Queries Examples

This is part 2 of the tutorial series - converting the popular Microsoft Access Northwind database queries toMySQL queries. These queries are originated from Access Northwind Traders application. Some of them are relatively complex aggregated queries with sub-queries.

6. Order Details Extended

Northwind Database Sql Queries

This query calculates sales price for each order after discount is applied.

Here is the query result. 2,155 records returned.

Northwind Database Assignment Query 9: Using JOIN and Aggregate Function. The most common format is the Structured Query Language (SQL) standard query format that many database management systems use. SQL is a powerful language capable of advanced queries. SQL uses a SELECT statement to select specific data. Consider an example based on the Northwind database that frequently ships with database products as a tutorial. Name: The relationships for the Northwind Database are shown below. Paste the SQL statements for the queries below the query statements. OutOfStockProducts: Make a. Sql 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.

7. Sales by Category

For each category, we get the list of products sold and the total sales amount.Note that, in the second query, the inner query for table c is to get sales for each product on each order. It then joins with outer query on Product_ID. In the outer query, products are grouped for each category.

Northwind Database Script Sql

Here is the query result. 77 records returned.

8. Ten Most Expensive Products

Queries In Sql

The two queries below return the same result. It demonstrates how MySQL limits the number of records returned.

Northwind database sql queries list

The first query uses correlated sub-query to get the top 10 most expensive products.

The second query retrieves data from an ordered sub-query table and then the keyword LIMIT is used outside the sub-query to restrict the number of rows returned.

Here is the query result. 10 records returned.

9. Products by Category

This is a simple query just because it's in Access Northwind so we converted it here in MySQL.

Here is the query result. 69 records returned.

10. Customers and Suppliers by City

This query shows how to use UNION to merge Customers and Suppliers into one result set by identifying them as having different relationships to Northwind Traders - Customers and Suppliers.

Here is the query result. 120 records returned.

Sql Queries On Northwind Database


Install Northwind Database Sql

Other tutorials in this category

Northwind Database Sql Queries Examples

1. MySQL Northwind Queries - Part 1
2. MySQL Northwind Queries - Part 3
3. How to Work with Two Unrelated Values
4. How to Fill Gaps in Sales Data
5. How to Calculate Totals, Subtotals and Grand Total
6. How to Work with NULL Values
7. How to fill down empty cells with values from a previous non-empty row
8. Use RANK function to update a previous record within a group or partition
9. Two ways to add a unique number or ID to each row
10. 3 ways to get Top N rows from MySQL
11. How to generate Cumulative Sum (running total) by MySQL - Part 1