《SQL查询凡人入门》学习笔记之一

一、销售订货数据库
1、SELECT VendName FROM Vendors
2、SELECT productName,Retailprice FROM products
3、SELECT DISTINCT Custstate FROM Customers
二、娱乐数据库
1、SELECT Entcity,EntstageName
   FROM Entertainers
   ORDER BY Entcity ASC,EntstageName ASC
2、SELECT DISTINCT StartDate FROM Engagements
三、学校日程安排数据库
1、SELECT * FROM Classes
2、SELECT BuildingName,Numberoffloors
   FROM Buildings
   ORDER BY BuildingName
四、保龄球协会数据库
1、SELECT DISTINCT TourneyLocation
   FROM Tournaments
2、SELECT TourneyDate,TourneyLocation
     FROM Tournaments
     ORDER BY TourneyDate DESC,TourneyLocation ASC
五、食谱数据库
1、SELECT RecipeClassID,RecipeTitle
      FROM Recipes
      ORDER BY RecipeClassID ASC,RecipeTitle ASC
2、SELECT DISTINCT RecipeClassID
      FROM Recipes