{"id":1444,"date":"2022-11-15T16:23:18","date_gmt":"2022-11-15T08:23:18","guid":{"rendered":"https:\/\/aic.leexinghai.com\/?p=1444"},"modified":"2022-11-15T16:23:18","modified_gmt":"2022-11-15T08:23:18","slug":"h21114-%e8%af%be%e5%90%8e%e7%bb%83%e4%b9%a01-121%e9%a1%b5%e4%ba%8c1-4","status":"publish","type":"post","link":"https:\/\/www.leexinghai.com\/aic\/h21114-%e8%af%be%e5%90%8e%e7%bb%83%e4%b9%a01-121%e9%a1%b5%e4%ba%8c1-4\/","title":{"rendered":"H21114-\u8bfe\u540e\u7ec3\u4e601-121\u9875\u4e8c1-4"},"content":{"rendered":"\n<p>1.\u674e\u660e\u5728\u54ea\u4e9b\u8bfe\u7a0b\u5f97\u5230\u7684\u5206\u6570\u8d85\u8fc780\uff1f\u5217\u51fa\u8bfe\u7a0b\u540d<\/p>\n\n\n\n<p>select cname from C join SC on SC.cno=C.cno join S on S.sno=SC.sno and SC.score&gt;\u201980\u2019<\/p>\n\n\n\n<p>where S.sname='\u674e\u660e'<\/p>\n\n\n\n<p>2.\u5217\u51fa\u6ca1\u6709\u9009\u4fee\u201c\u4eba\u5de5\u667a\u80fd\u201d\u8bfe\u7a0b\u7684\u5b66\u751f\u59d3\u540d\u3001\u5e74\u9f84\u3002<\/p>\n\n\n\n<p>select sname,sage from S where sno not in<\/p>\n\n\n\n<p>(select sno from SC where cno&nbsp; in(select cno from C where cname='\u4eba\u5de5\u667a\u80fd'))<\/p>\n\n\n\n<p>3.\u54ea\u4e9b\u5b66\u751f\u201c\u6570\u636e\u5e93\u201d\u8bfe\u7a0b\u7684\u6210\u7ee9\u8981\u9ad8\u4e8e\u738b\u7ea2\u7684\u6570\u636e\u5e93\uff1f\u5217\u51fa\u5b66\u53f7\u3001\u59d3\u540d\u3002<\/p>\n\n\n\n<p>select S.sno,sname from S<\/p>\n\n\n\n<p>join SC on S.sno=SC.sno join C on SC.cno=C.cno and cname='\u6570\u636e\u5e93' and SC.score&gt;( select score from SC<\/p>\n\n\n\n<p>join S on S.sno=SC.sno join C on SC.cno=C.cno and cname='\u6570\u636e\u5e93'<\/p>\n\n\n\n<p>where sname='\u738b\u7ea2')<\/p>\n\n\n\n<p>4.\u5217\u51fa\u738b\u98ce\u8001\u5e08\u6559\u7684\u6bcf\u95e8\u8bfe\u7a0b\u7684\u6700\u9ad8\u5206\u3002<\/p>\n\n\n\n<p>select SC.cno,max(score),C.cname from SC join C on SC.cno=C.cno join T on C.tno=T.tno and T.tname='\u738b\u98ce'<\/p>\n\n\n\n<p>group by SC.cno,C.cname<\/p>\n\n\n\n<p>4.\u5217\u51fa\u738b\u98ce\u8001\u5e08\u6559\u7684\u6bcf\u95e8\u8bfe\u7a0b\u7684\u6700\u9ad8\u5206\u3002<\/p>\n\n\n\n<p><code>select sc.cno,max(score),course.cname from sc join course on sc.cno=course.cno join teacher on course.tno=teacher.tno and teacher.tname='\u738b\u98ce' group by sc.cno,course.cname<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u674e\u660e\u5728\u54ea\u4e9b\u8bfe\u7a0b\u5f97\u5230\u7684\u5206\u6570\u8d85\u8fc780\uff1f\u5217\u51fa\u8bfe\u7a0b\u540d select cname from C join SC on [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-1444","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dtba"],"_links":{"self":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/posts\/1444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/comments?post=1444"}],"version-history":[{"count":0,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/posts\/1444\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/media?parent=1444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/categories?post=1444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.leexinghai.com\/aic\/wp-json\/wp\/v2\/tags?post=1444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}