第四届CCSP 第三题 SQL查询
TimeLimit:10000MS MemoryLimit:1024MB
64-bit integer IO format:%lld
未提交 | 登录后收藏
Problem Description
![$B3_(]{K}5{_~G5U{FK5IB9.png](pic/upload/20211005/1633439777980059985.png "1633439777980059985.png")
![%K8ZA1RM(LL]G9UDI]0U]EL.png](pic/upload/20211005/1633439781496009066.png "1633439781496009066.png")
![@GKG~~]4%G9CAE35DN`UR~X.png](pic/upload/20211005/1633439785201056910.png "1633439785201056910.png")
![AO{DJ)WI]`3L}MGKE1}62RX.png](pic/upload/20211005/1633439792672046738.png "1633439792672046738.png")
![4}]9@~J7OUZ703FG$0[(~P3.png](pic/upload/20211005/1633439797084048025.png "1633439797084048025.png")
Input
3
2019001 law 19
2019002 info 20
2019003 info 19
2
20190001 math
20190002 English
2
2019101 info 49
2019102 info 38
2
2019002 20190001 100
2019003 20190002 0
1
20190001 2019102
4
SELECT * FROM Student
SELECT Student . dept FROM Student
SELECT Student.sid,Grade.sid,dept,score FROM Student,Grade
SELECT * FROM Student, Grade WHERE Grade .sid=Student. sid
Output
2019001 law 19
2019002 info 20
2019003 info 19
law
info
info
2019001 2019002 law 100
2019001 2019003 law 0
2019002 2019002 info 100
2019002 2019003 info 0
2019003 2019002 info 100
2019003 2019003 info 0
2019002 info 20 2019002 20190001 100
2019003 info 19 2019003 20190002 0
SampleInput
4 2019000001 law 19 2019000003 info 20 2019000002 info 19 2019010 math 28 4 2019010 math 2019011 math 2019012 Course 2019013 SELECT 4 2019010 math 0 2019000002 info 19 2019000001 math 100 2019000000 ABC 38 2 2019000001 2019010 90 2019010 2019010 99 1 2019013 2019000000 7 SELECT * FROM Grade SELECT cid FROM Grade SELECT cid,cid,Grade.cid, sid FROM Grade SELECT * FROM Grade, Student SELECT * FROM Grade, Student WHERE dept="info" AND Student.age < 100 AND score> 90 SELECT Student.sid, dept, score FROM Grade,Student WHERE Student.sid = Grade.sid SELECT Student.sid, dept, score FROM Grade,Student WHERE Student.sid = Grade.sid AND cid = "2019"
SampleOutput
2019000001 2019010 90 2019010 2019010 99 2019010 2019010 2019010 2019010 2019010 2019000001 2019010 2019010 2019010 2019010 2019000001 2019010 90 2019000001 law 19 2019000001 2019010 90 2019000003 info 20 2019000001 2019010 90 2019000002 info 19 2019000001 2019010 90 2019010 math 28 2019010 2019010 99 2019000001 law 19 2019010 2019010 99 2019000003 info 20 2019010 2019010 99 2019000002 info 19 2019010 2019010 99 2019010 math 28 2019010 2019010 99 2019000003 info 20 2019010 2019010 99 2019000002 info 19 2019000001 law 90 2019010 math 99