【正文】
TOP 10 AS單價(jià)之和FROM Products,正確的SQL是()A. SELECT MIN (UnitPrice) AS最高單價(jià)FROM ProductsB. SELECT AVG (UnitPrice) AS最高單價(jià)FROM ProductsC. SELECT MAX (UnitPrice) AS最高單價(jià)FROM ProductsD. SELECT MAX UnitPrice AS最高單價(jià)FROM Products5. 從產(chǎn)品表Products中查詢單價(jià)UnitPrice在6~10的產(chǎn)品名稱和單價(jià)信息,正確的SQL有()A.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10B.SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6C. SELECT Name,UnitPrice FROM Products WHERE UnitPrice IN( 6,10)D.SELECT Name,UnitPrice FROM Products WHERE UnitPrice= 6 AND UnitPrice =10 第六章 分組查詢和連接查詢 綜合測試題有訂單表Orders,. 訂單號OrderID訂單日期OrderDate訂單金額OrderAmount客戶編號CID1201304086501220130223112023201305177603420130611475252013042028016201302233602720130308550382013040879029201307221260310201308149703 有客戶表Customer,.客戶編號CustomerID客戶姓名Name客戶所在地Address1劉小慧武漢2張震東上海3安忠峰上海分析上述兩個(gè)表,回答下列