Suppose a student can check out as many books as the number of courses he/she is

Question

Suppose a student can check out as many books as the number of courses he/she is enrolled in. Write an SQL query that returns studentid and name of students who can not check out any more books. Your answer should include students who didn’t enroll in any course.

book bookid title Introduction of Algorithms rice total copies 84.66 Database System Concepts74.99 Stochastic Calculus for Financ41.02 Stochastic Calculus for Finance II 55.22 course title Algorithms DB Organization Advanced DB Organization Math Finance I Math Finance II faculty enroll studentid courseid student studentid facultyid name gpa Tom 3.3 John3.8 Mary 3.0 Kris 3.6 Alex3.5 James 70000 Sarah 60000 ay 80000 Rache 70000 Pau85000 book_ checkout bookid studentid 2017-08-29 2017-09-02 2017-09-07

Explanation / Answer

SQL query :

SELECT studentid, name

FROM student

WHERE studentid NOT EXISTS ( SELECT enroll.studentid FROM enroll )

Explanation :

Sub-query "SELECT enroll.studentid FROM enroll" will return the list of studentid of all the students which are enrolled in any course. Then main query will return studentid and name of all the students whose studentid does not exist in the list of studentid returned by the above sub-query.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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