{"id":781,"date":"2022-10-19T18:35:41","date_gmt":"2022-10-19T10:35:41","guid":{"rendered":"https:\/\/qaqaq.top\/?p=781"},"modified":"2022-11-27T12:43:52","modified_gmt":"2022-11-27T04:43:52","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e7%ac%ac%e5%9b%9b%e7%ab%a0%e5%ae%9e%e9%aa%8c","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=781","title":{"rendered":"\u6570\u636e\u5e93\u7b2c\u56db\u7ae0\u5b9e\u9a8c"},"content":{"rendered":"\n
1.\nSELECT Sno, Sname FROM Student<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
2.\nSELECT Sname,Sno,Sdept FROM Student<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
3.\nSELECT * FROM Student<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
4.\nSELECT Sname, 2022 - Sage FROM Student<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
5.\nSELECT Sname, '\u51fa\u751f\u5e74\u4efd', 2022 - Sage FROM Student<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
6.\nSELECT Sno FROM SC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
7.\nSELECT Sname FROM Student WHERE Sdept = '\u8ba1\u7b97\u673a\u7cfb'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
8.\nSELECT Sname , Sage FROM Student WHERE Sage < 20<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
9.\nSELECT DISTINCT Sno FROM SC WHERE Grade < 60<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
10.\nSELECT Sname,Sdept,Sage FROM Student\nWHERE Sage BETWEEN 20 AND 23<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
11.\nSELECT Sname,Sdept,Sage FROM Student\nWHERE Sage NOT BETWEEN 20 AND 23<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
12.\nSELECT Sname,Ssex FROM Student\nWHERE Sdept IN ('\u4fe1\u606f\u7cfb','\u6570\u5b66\u7cfb','\u8ba1\u7b97\u673a\u7cfb')<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
13.\nSELECT Sname,Ssex FROM Student\nWHERE Sdept NOT IN ('\u4fe1\u606f\u7cfb','\u6570\u5b66\u7cfb','\u8ba1\u7b97\u673a\u7cfb')<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
14.\nSELECT * FROM Student WHERE Sname LIKE '\u5f20%'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
15.\nSELECT * FROM Student WHERE Sname LIKE '[\u5f20\u674e\u5218]%'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
16.\nSELECT Sname,Sno FROM Student WHERE Sname LIKE '_[\u5c0f\u5927]%'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
17.\nSELECT Sname FROM Student WHERE Sname NOT LIKE '[\u738b\u5f20]%'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
18.\nSELECT Sname FROM Student WHERE Sname LIKE '\u738b_'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
19.\nSELECT Sname FROM Student WHERE Sname LIKE '\u738b__'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
20.\nSELECT Sno, Cno FROM SC WHERE GRADE IS NULL<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
21.\nSELECT Sno, Cno FROM SC WHERE GRADE IS NOT NULL<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
22.\nSELECT Sname,Sage FROM Student\nWHERE Sdept = '\u8ba1\u7b97\u673a\u7cfb' AND Sage < 20<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
23.\nSELECT Sname, Sdept,Sage FROM Student\nWHERE (Sdept = '\u8ba1\u7b97\u673a\u7cfb' OR Sdept = '\u4fe1\u606f\u7cfb')\nAND Sage >= 20<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
24.\nSELECT * FROM Student ORDER BY Sage ASC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
25.\nSELECT Sno,Grade FROM SC\nWHERE Cno = 'c002' ORDER BY Grade DESC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
26.\nSELECT * FROM Student ORDER BY Sdept, Sage DESC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
27.\nSELECT COUNT(*) AS \u5b66\u751f\u4eba\u6570 FROM Student<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
28.\nSELECT COUNT(DISTINCT Sno) \u9009\u8bfe\u4eba\u6570 FROM SC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
29.\nSELECT COUNT(*) AS \u9009\u8bfe\u4eba\u6570, SUM(Grade) AS \u603b\u6210\u7ee9\nFROM SC WHERE Sno = '1512101'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
30.\nSELECT AVG(Grade) AS \u5e73\u5747\u6210\u7ee9 FROM SC WHERE Cno = 'c001'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
31.\nSELECT MAX(Grade) AS \u6700\u9ad8\u5206, MIN(Grade) AS \u6700\u4f4e\u5206 \nFROM SC WHERE Cno = 'c001'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
32.\nSELECT COUNT(*) AS \u9009\u8bfe\u95e8\u6570, COUNT(Grade) AS \u8003\u8bd5\u95e8\u6570,\nMAX(Grade) AS \u6700\u9ad8\u5206, MIN(Grade) AS \u6700\u4f4e\u5206,\nAVG(Grade) AS \u5e73\u5747\u5206\nFROM SC WHERE Sno = '1512101'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
33.\nSELECT Cno AS \u8bfe\u7a0b\u53f7,COUNT(Sno) AS \u9009\u8bfe\u4eba\u6570\nFROM SC GROUP BY Cno<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
34.\nSELECT Sno \u5b66\u53f7,COUNT(*) \u9009\u8bfe\u95e8\u6570,AVG(Grade) \u5e73\u5747\u6210\u7ee9\r\nFROM SC\r\nGROUP BY Sno<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
35.\nSELECT Sdept, COUNT(*) AS \u5b66\u751f\u4eba\u6570, AVG(Sage) AS \u5e73\u5747\u5e74\u9f84\r\nFROM Student GROUP BY Sdept<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
36.\nSELECT Sdept, Count(*) \u5973\u751f\u4eba\u6570 FROM Student\r\nWHERE Ssex = '\u5973'\r\nGROUP BY Sdept<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
37.\nSELECT Sdept, Ssex, Count(*) \u4eba\u6570, MAX(Sage) \u6700\u5927\u5e74\u9f84\r\nFROM Student\r\nGROUP BY Sdept, Ssex\r\nORDER BY Sdept<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
38.\nSELECT Sno,COUNT(*) \u9009\u8bfe\u95e8\u6570,AVG(Grade) \u5e73\u5747\u4eba\u6570 FROM SC\r\nGROUP BY Sno\r\nHAVING COUNT(*) > 3<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
39.\nSELECT Sno,COUNT(*) \u9009\u8bfe\u95e8\u6570,AVG(Grade) \u5e73\u5747\u4eba\u6570 \r\nFROM SC\r\nGROUP BY Sno\r\nHAVING AVG(Grade) >= 80<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
40.\nSELECT Sdept, COUNT(*) \u4eba\u6570\r\nFROM Student\r\nWHERE Ssex = '\u7537'\r\nGROUP BY Sdept\r\nHAVING COUNT(*) >= 2<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
41.\nSELECT * FROM Student INNER JOIN SC\r\nON Student.Sno = SC.Sno<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
42.\nSELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,Grade\r\nFROM Student JOIN SC ON Student.Sno = SC.Sno<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
43.\nSELECT Student.Sno,Sname,Cno,Grade FROM Student JOIN SC \r\nON Student.Sno = SC.Sno\r\nWHERE Sdept = '\u8ba1\u7b97\u673a\u7cfb'\r<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
44.\nSELECT Sname,Cname,Grade \nFROM Student JOIN SC ON Student.Sno = SC.Sno\nJOIN Course ON Course.Cno = SC.Cno\nWHERE Sdept = '\u8ba1\u7b97\u673a\u7cfb'\r\nAND Cname = '\u8ba1\u7b97\u673a\u6587\u5316\u5b66'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
45.\nSELECT Sname,Sdept FROM Student \nJOIN SC ON Student.Sno = SC.Sno\nJOIN Course ON Course.Cno = SC.Cno\nWHERE Cname = 'Java'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
46.\nSELECT Sdept, AVG(Grade) as AverageGrade\r\nFROM Student JOIN SC ON Student.Sno = SC.Sno\r\nGROUP BY Sdept<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
47.\nSELECT Cno, COUNT(*) AS Total, AVG(Grade) as AvgGrade,\r\nMAX(Grade) as MaxGrade, MIN(Grade) as MinGrade\r\nFROM Student JOIN SC ON Student.Sno = SC.Sno\r\nWHERE Sdept = '\u8ba1\u7b97\u673a\u7cfb'\r\nGROUP BY Cno<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
48.\nSELECT S2.Sname,S2.Sdept FROM Student S1 JOIN Student S2\r\nON S1.Sdept = S2.Sdept\r\nWHERE S1.Sname = '\u5218\u6668'\r\nAND S2.Sname != '\u5218\u6668'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
49.\nSELECT C1.Cname,C1.Credit\r\nFROM Course C1 JOIN Course C2\r\nON C1.Credit = C2.Credit\r\nWHERE C2.Cname = '\u6570\u636e\u7ed3\u6784'<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
50.\nSELECT Student.Sno, Sname, Cno, Grade\r\nFROM Student LEFT OUTER JOIN SC\r\nON Student.Sno = SC.Sno<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
51.\nSELECT Cname FROM Course LEFT JOIN SC\r\nON Course.Cno = SC.Cno\r\nWHERE SC.Cno IS NULL<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
52.\nSELECT TOP 3 Sname,Sage,Sdept\r\nFROM Student\r\nORDER BY Sage DESC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
53.\nSELECT TOP 3 WITH TIES Sname,Sdept,Grade\r\nFROM Student JOIN SC ON Student.Sno = SC.Sno\r\nJOIN Course ON Course.Cno = SC.Cno\r\nWHERE Cname = 'Java'\r\nORDER BY GRADE DESC<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[57],"class_list":["post-781","post","type-post","status-publish","format-standard","hentry","category-25","tag-57"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/781"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=781"}],"version-history":[{"count":3,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/781\/revisions"}],"predecessor-version":[{"id":997,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/781\/revisions\/997"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}