|
Execute the following
Microsoft SQL Server T-SQL query in SSMS Query Analyzer to list all the order ids with order quantity
in the bottom quartile:
-- SQL correlated subquery
SELECT DISTINCT o.OrderId, o.ProductID
FROM Northwind.dbo.[Order Details] o
WHERE Quantity <= (SELECT avg(Quantity) * .25
FROM Northwind.dbo.[Order Details]
WHERE o.ProductID = ProductID)
/*
OrderId ProductID
10609 1
10700 1
10838 1
11003 1
11005 1
10851 2
10722 2
....
*/
|