• Categories:产品类别；
• Customers：客户；
• Employees:雇员
• Employees Territories:员工涉及领域
• Order Details：订单明细
• Orders：订单
• Products：产品
• Region：地区
• Shippers：运货商
• Suppliers：供应商
• Territories：地域

select productid,productname,unitprice from Products
where UnitPrice>49

select productid,productname,UnitsInStock,UnitsOnOrder
 from Products where UnitsInStock<UnitsOnOrder

select * from Products
where ProductName='Aniseed Syrup' or ProductName='Ipoh Coffee'

select * from Products
where ProductName in('Aniseed Syrup','Ipoh Coffee')

select * from Products
where SupplierID=CategoryID

select SupplierID,CompanyName,Phone,Fax from Suppliers
where Phone is not null and fax is null

select * from Suppliers
order by City  desc

select SupplierID,CompanyName,Country from Suppliers
where Country in('USA','UK','Germany')

select SupplierID,CompanyName,ContactTitle,Phone 
from Suppliers
where  ContactTitle='Marketing Manager' and Phone is not null

select distinct ShipVia from Orders

select distinct ShipCity from Orders

select OrderID,ShippedDate,RequiredDate from Orders
where ShippedDate>RequiredDate

select OrderID,CustomerID,Freight from Orders
where Freight<55

select * from Categories
where CategoryName like '_e%'

select * from Categories
where Description like '%sweet%'