1、 請查出AUTHORS表中所有在城市OAKLAND的人的所有記錄。2、 查找出AUTHORS表中每個STATE中ZIP的最大值。3、 請統(tǒng)計出SALES表中QTY的總數(shù)，并以“總量”為標(biāo)題顯示該數(shù)據(jù)。4、 請將TITLES表中的BUSINESS的所有PRICE求平均值。5、 查找出AUTHORS表中STATE不是CA的CITY。原語句：1、SELECT *, city AS Expr1 FROM authors WHERE (city = 'OAKLAND')2、SELECT COUNT(*) AS Expr1, state, MAX(zip) AS 最大值 FROM authors GROUP BY state3、SELECT COUNT(*) AS Expr1, SUM(qty) AS 總量 FROM sales4、SELECT COUNT(*) AS Expr1, AVG(price) AS 平均值 FROM titles WHERE (type = 'BUSINESS')5、select city,state AS expr1 from authors where (NOT (state IN ('CA')))可不可以改成這樣的語句：1、SELECT *, city FROM authors WHERE (city = 'OAKLAND')2、 SELECT state, MAX(zip) AS 最大值 FROM authors GROUP BY state3、 SELECT COUNT(*), SUM(qty) AS 總量 FROM sales4、 SELECT COUNT(*), AVG(price) AS 平均值 FROM titles WHERE (type = 'BUSINESS')5、 SELECT city FROM authors WHERE (NOT (state IN ('CA')))前面一個是原語句，后面是朋友幫我改的語句，我想請教各位高手，能不能將“AS Expr1”去掉，或者干脆將后面朋友寫的語句中的“COUNT(*), ”去掉，請高手將最好最正確的語句寫給我，謝謝！20號之前要答案。多謝了！我是初學(xué)者，搞不清楚什么時候要用“AS Expr1”以及不知什么時候要用到“COUNT(*), ”請順便幫我解答一下用法，多謝了。