用sql语句处理下列问题。求解答！！ 用SQL语句完成下列问题。
\u7528sql\u8bed\u53e5\u89e3\u51b3\u4e0b\u5217\u95ee\u9898\uff0c\u6c42\u89e3\u7b54\uff01\uff01\uff011\u3001\u5206\u6790\uff1a
\u6700\u540e\u8f93\u51fa\u7684\u7ef4\u5ea6\u5305\u542b\uff1a\u6838\u7b97\u5355\u4f4d\uff08\u91c7\u8d2d\u7c7b\u522b\uff09\u3001\u6708\u4efd\u3001\u4f9b\u5e94\u5546\u3001\u5b9e\u9645\u5165\u5e93\u6570\u91cf\u3001\u5b9e\u9645\u5165\u5e93\u5747\u4ef7\u3001\u5b9e\u9645\u5165\u5e93\u91d1\u989d
2\u3001\u65b9\u6848\uff1a\u6309\u7167\u524d\u4e09\u4e2a\u7ef4\u5ea6\u8fdb\u884cgroup by\u5373\u53ef\u3002
select
\u6838\u7b97\u5355\u4f4d\uff08\u91c7\u8d2d\u7c7b\u522b\uff09,
\u6708\u4efd,
\u4f9b\u5e94\u5546,
sum(\u5b9e\u9645\u5165\u5e93\u6570\u91cf) as \u5b9e\u9645\u5165\u5e93\u6570\u91cf,
sum(\u5b9e\u9645\u5165\u5e93\u91d1\u989d) as \u5b9e\u9645\u5165\u5e93\u91d1\u989d,
sum(\u5b9e\u9645\u5165\u5e93\u91d1\u989d) / sum(\u5b9e\u9645\u5165\u5e93\u6570\u91cf) as \u5b9e\u9645\u5165\u5e93\u5747\u4ef7
from PurchaseAnalys\uff08\u91c7\u8d2d\u8fdb\u8d27\u660e\u7ec6\u8868\uff09
where \u6708\u4efd between '2016-07-01' and '2016-12-31'
GROUP BY \u6838\u7b97\u5355\u4f4d\uff08\u91c7\u8d2d\u7c7b\u522b\uff09,\u6708\u4efd,\u4f9b\u5e94\u5546
ORDER BY \u6708\u4efd,\u6838\u7b97\u5355\u4f4d\uff08\u91c7\u8d2d\u7c7b\u522b\uff09,\u4f9b\u5e94\u5546;
1\u3001\u7b2c\u4e00\u9898\uff0c\u662f\u67e5\u8be2\u603b\u548c\uff0c\u603b\u548c\u5728SQL\u4e2d\u4f7f\u7528sum\uff0c\u5982\uff1aselect sum(\u6210\u7ee9) from \u8868\u540d
2\u3001\u7b2c\u4e8c\u9898\uff0c\u67e5\u8be2\u5e73\u5747\u503c\uff0cSQl\uff1aselect \u5b66\u53f7\uff0cAvg(sum(\u6210\u7ee9)) from \u8868\u540d group by \u5b66\u53f7
3\u3001\u7b2c\u4e09\u9898\uff0c\u67e5\u8be2\u6bcf\u8bfe\u7a0b\u5b66\u751f\u4eba\u6570\uff0cSQL : select \u8bfe\u7a0b\u540d\u79f0,count(\u5b66\u53f7) from \u8868\u540d group by \u8bfe\u7a0b\u540d\u79f0
4\u3001\u7b2c\u56db\u9898\uff0c\u67e5\u8be2\u6700\u9ad8\u5206\uff0c\u4e5f\u5c31\u662f\u6700\u5927\u503c,select max(\u6210\u7ee9),\u5b66\u53f7 from \u8868\u540d group by \u5b66\u53f7
5\u3001\u7b2c\u4e94\u9898\uff0c\u67e5\u8be2\u6bcf\u79d1\u7684\u6700\u9ad8\u5206\uff0cSQL:select max(\u6210\u7ee9),\u8bfe\u7a0b from \u8868\u540d group by \u8bfe\u7a0b \u6700\u4f4e\u5206 select min(\u6210\u7ee9),\u8bfe\u7a0b from \u8868\u540d group by \u8bfe\u7a0b \u5e73\u5747\u5206 select Avg(sum(\u6210\u7ee9)),\u8bfe\u7a0b from \u8868\u540d group by \u8bfe\u7a0b
6\u3001\u7b2c\u516d\u9898 \u663e\u793a\u7efc\u5408\u5927\u4e8e250\u5206\u7684\u4fe1\u606f SQL: select \u5b66\u751fID,sum(\u6210\u7ee9) \u603b\u5206 from \u8868\u540d where sum(\u6210\u7ee9)>250 group by \u5b66\u751fID
7\u3001\u7b2c\u4e03\u9898 \u663e\u793a\u5e73\u5747\u5206 SQL:select \u5b66\u751fID,Avg(sum(\u6210\u7ee9)),\u8bfe\u540d from \u8868\u540d where sum(\u6210\u7ee9)>250 group by \u5b66\u751fID,\u8bfe\u540d order by Avg(sum(\u6210\u7ee9)) asc
8\u3001\u7b2c\u516b\u9898 \u67e5\u8be2\u4eba\u6570 SQL:select \u8bfe\u7a0bID,sum(\u5b66\u751fID) from \u8868\u540d where sum(\u5b66\u751fID)>=30 group by \u8bfe\u7a0bID
9\u3001\u7b2c\u4e5d\u9898 \u67e5\u8be2\u6700\u9ad8\u5206 SQL:select max(\u6210\u7ee9),\u8bfe\u7a0b,\u5b66\u751f\u540d\u5b57 from \u8868\u540d where max(\u6210\u7ee9)>=90 group by \u8bfe\u7a0b,\u5b66\u751f\u540d\u5b57
10\u3001\u7b2c\u5341\u9898 \u6210\u7ee9>=60,\u5e73\u5747\u5206>85 SQL:select \u5b66\u751f from \u8868\u540d where avg(sum(\u6210\u7ee9))>85 and min(\u6210\u7ee9)>=60 order by avg(sum(\u6210\u7ee9)) desc
\u597d\u8f9b\u82e6\uff0c\u671b\u91c7\u7eb3
绛旓細1.鏌ヨ鎵鏈夊晢鍝佺殑鍟嗗搧鍚嶃佸崟浠枫佹暟閲忥紱Select鍟嗗搧鍚,鍗曚环,鏁伴噺 From 鍟嗗搧 ---銆 鏀逛负锛 鍙峰嵆鍙 2.鏌ヨ鍖椾含鐨勪粨搴撲俊鎭紱1绉嶆柟娉昐elect * from 浠撳簱 where 浠撳簱鍚=鈥欏寳浜2绉嶆柟娉昐elect浠撳簱鍙,浠撳簱鍚,鍦板潃,闈㈢Н From 浠撳簱 Where 浠撳簱鍚=鈥欏寳浜(鍝釜瀵) ---閮藉 3.鏌ヨ闈㈢Н涓嶄綆浜100鐨...
绛旓細select age, count(*) as [浜烘暟] from S where sex='鐢'group by age having count(*)>50 order by [浜烘暟]asc ,age desc
绛旓細涓嶉渶瑕佺粨鏋 select sname from student s,course c,sc where s.sno=sc.sno and c.cno=sc.cno and c.cno='c1' and sdept='is'鍏ㄩ儴閮芥槸鑷繁鎵嬪啓锛屽懙鍛碉紝鎴戜篃鏄垰瀛︽暟鎹簱锛岃繕濂戒細鍋氾紝鑺变簡涓浜涙椂闂村憿锛屽笇鏈涙ゼ涓荤湅鐨勬噦 閮借繍琛岄氳繃浜嗭紝涓嶆噦鍙互鎵炬垜锛岄偖绠眞[email protected] ...
绛旓細1select sno,sname from s where ssex='濂' and sage=192select cname,clocation from c where clocation='涓绘ゼ' order by teacher3select sno from sc where grade>=80 and cno in (select cno from c where cname='鏁版嵁搴撳師鐞')4select s.sno,s.sname,avg(grade) from s,c,sc where ...
绛旓細select 渚涘簲鍟嗗彿锛屽伐绋嬪彿锛屾暟閲 into sup_temp from 琛 order by 鏁伴噺 desc
绛旓細1 select b.璇剧▼鍚,isnull(count(*),0)from 璇剧▼琛 a,鎴愮哗琛 b on a.璇剧▼鍙=b.璇剧▼鍙 group by b.璇剧▼鍚 2 select a.濮撳悕,b.璇剧▼鍚,c.鎴愮哗 from 瀛︾敓琛 a,璇剧▼琛 b,鎴愮哗琛 c where a.瀛﹀彿=c.瀛﹀彿 and b.璇剧▼鍙=c.璇剧▼鍙 and a.鎬у埆='濂' and b.璇剧▼鍚='璁＄畻鏈哄熀纭'3 杩...
绛旓細oralce sql 鏄繖涔堝啓鐨勶細缁熻姣忎釜瀛︾敓鐨勫钩鍧囨垚缁╁拰濮撳悕 select sname 濮撳悕,avg(grade) 鎴愮哗 from s,sc where s.sno=sc.sno group by sname;缁熻骞冲潎鎴愮哗瓒呰繃90鍒嗙殑瀛︾敓濮撳悕,瀛﹀彿鍜屾垚缁 select sname 濮撳悕锛宻.sno 瀛﹀彿,avg(grade) 鎴愮哗 from s,sc where s.sno=sc.sno group by sname having ...
绛旓細INSERT INTO BOOK_(涔﹀悕锛屼綔鑰咃紝浠锋牸)SELECT 涔﹀悕锛屼綔鑰咃紝浠锋牸 from 鍥句功!book inner join xxx浣犵殑閭ｉ儴鍒嗕唬鐮 order by book.浠锋牸 desc
绛旓細FROM J, SPJ WHERE J.J# = SPJ.J GROUP BY J.J#, J.JNAME;杩欏摜瑙嗗浘閫夊彇浜咼鍜孲PJ涓や釜鍏崇郴锛屽叧鑱旀潯浠舵槸J.J#=SPJ.J#銆備娇鐢℅ROUP BY瀛愬彞瀵笿.J#鍜孞.JNAME杩涜鍒嗙粍锛岀劧鍚庝娇鐢⊿UM鍑芥暟璁＄畻姣忎釜宸ョ▼椤圭洰浣跨敤闆朵欢鐨勬绘暟銆傜劧鍚 2.姹傞噸閲忔渶杞荤殑闆朵欢鐨勯浂浠跺彿 鍙互浣跨敤濡備笅SQL璇彞姹傝В锛歋ELECT P FROM P...
绛旓細2. select 鏉″舰鐮侊紝鑽搧鍚 as 鍚嶇О锛 鍏ュ簱鏁伴噺锛 鍗曚环锛岋紙鍏ュ簱鏁伴噺*鍗曚环锛塧s 閲戦 from 鑽簱 3. select * from 鑽簱 where 锛堝叆搴撴暟閲 - 鍑哄簱鏁伴噺锛 > 0 4. select sum(鍗曚环*锛堝嚭搴撴暟閲忥級) from 鑽簱 where datepart(yyyy,getdate()) = datepart(yyyy,鍑哄簱鏃堕棿) group by datepart锛坢m,...
