Find the IDs of all the students (sid), whose grade in ‘EE401’ is lower than the

Question

Find the IDs of all the students (sid), whose grade in ‘EE401’ is lower than their grade in ‘CS595’.

List all the students (sid and name) who never got a grade lower than ‘B’ (grade point below 3.0).

Consider the following database schema and example instance: Course Student title Databases dept credits cid CS425 name dept sid 001 Alice CS 002 Bob EE 003 Carol CS 004 David PHYS CS CS595 Database Security CS EE VLSI Design EE 3 591 Microcomputers EE401 4 PHYS571 Radiation Physics PHYS 3 Enroll sid grade gradepoint cid CS425001A CS595 001B CS595 002A EE401 001 A EE401 002 B EE401 004 A 4.0 3.0 4.0 4.0 3.0 4.0 2.0 4.0 Prereq cid pi CS595 CS425 EE591 EE401 PHYS571 002 C PHYS571 004A Hints: Attributes shown with grey background form the primary key of a relation.

Explanation / Answer

Answers :

Q.Find the IDs of all the students (sid), whose grade in ‘EE401’ is lower than their grade in ‘CS595’.

Answer :

select student.sid from student where student.sid = enroll.sid and where
enroll.gradepoint<'4.0';

Output : 002

Q.List all the students (sid and name) who never got a grade lower than ‘B’ (grade point below 3.0).

Answer:

select student.sid,student.sname from student where student.sid=enroll.sid and
enroll.gradepoind>'3.0';
Output :
001 Alice
002 Bob
004 David

Thanks...

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.