Northwind学习笔记

--1.查询订购日期在1996年7月1日至1996年7月15日之间的订单的订购日期、订单ID、客户ID和雇员ID等字段的值

SELECT OrderID ,
       CustomerID ,
       EmployeeID ,
       OrderDate FROM dbo.Orders WHERE OrderDate BETWEEN ‘19960701‘ AND ‘19960715‘

--6.查询“10248”和“10254”号订单的订单ID、运货商的公司名称、订单上所订购的产品的名称

SELECT a.OrderID AS ‘订单ID‘,a.ShipName AS ‘运货商的公司‘,d.ProductName AS ‘产品的名称‘ FROM [dbo].[Orders] AS a 
JOIN dbo.Shippers AS b ON b.ShipperID = a.ShipVia
 JOIN dbo.[Order Details] AS c ON c.OrderID = a.OrderID JOIN dbo.Products AS d ON d.ProductID = c.ProductID 
WHERE a.OrderID=10248 OR a.OrderID=10254;

--7.查询“10248”和“10254”号 ‘订单‘ 的订单ID、订单上所订购的‘产品‘的名称及其销售金额
SELECT a.OrderID AS ‘订单ID‘,c.ProductName AS ‘产品名‘,a.UnitPrice*a.Quantity AS ‘销售金额‘ FROM [dbo].[Order Details] AS a 
JOIN dbo.Orders AS b ON b.OrderID = a.OrderID 
JOIN dbo.Products AS c ON c.ProductID = a.ProductID WHERE a.OrderID=10248 OR a.OrderID=10254;