SQL problems SID: cName. major decision 123.3 Cornell EE 1223 OSU. LCS Y 123 OSU
ID: 3833830 • Letter: S
Question
SQL problems
SID: cName. major decision 123.3 Cornell EE 1223 OSU. LCS Y 123 OSU. EE 1233 U of O CS Y CS, N3 123e MIT. 2345 of O biology N3 345 Cornell bioengineering 345 Cornell EE N3 345 Cornell 345 MIT bioengineering, Y 543.3 MIT CS NT 678. Cornells history. No psychology. Y 678 Cornell history Y3 678. OSU 765.3 OSU history Y biology Y 876 MIT marine biology. N 876 MIT CS 8761 OSU Yo 987- OSU Student GPA 123 Army 390, 1000 2340 Bobo 360, 1500 345. Craig, 350, 500. MinimumAGPA 456 Doris 3.90 1000. major OSU. 3.75.3 543, Craig 3.40, 2000. OSU. EE 3.3 367. Edwardo 2.90. 2000 OSU. history 2.8. 6540 Amyo 3.90, 1000 U of O 3.6p 6789 Fay. .80. 200. biology Jay. 2.90, 1500 789 Gary 3.40, 800. 3.49 Cornell 876o Irene. 3.90. 400. EE 3.6 Cornell 987 Helen. .70. 800 historyo 3.63 Cornell psychology. 2.8 Cornell College SNmasU State enrollment MIT. bioengineering 3.3s NY 21000. Cornell MA 10000 MIT IMIT. marine biology, 3.5. of 25000.Explanation / Answer
sName
Bob
Irene
Count
3
cName
COUNT
Cornell
6
OSU
6
U of O
3
MIT
5
cName
AVG_GPA
U of O
3.675
a.cName = ‘Cornell’ and a.cName = ‘MIT’ and a.cName = ‘OSU’ and
a.cName = ‘U of O’
sName
sID
Amy
123
a.cName IN (‘OSU’) and a.cName IN (‘U of O’)
sName
sID
Fay
678
Irene
876
sName
GPA
cName
major
Amy
3.9
Cornell
EE
Amy
3.9
OSU
CS
Amy
3.9
OSU
EE
Amy
3.9
U of O
CS
Craig
3.5
Cornell
CS
Fay
3.8
Cornell
History
Fay
3.8
Cornell
Psychology
Fay
3.8
OSU
History
Jay
2.9
OSU
History
Irene
3.9
MIT
biology
Irene
3.9
MIT
marine biology
Irene
3.9
OSU
CS
Helen
3.7
U of O
CS
sName
Bob
Irene
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.