17:45 cs.iit.edu Pad 78% D book bookid title Introduction of Algorithms Database

Question

17:45 cs.iit.edu Pad 78% D book bookid title Introduction of Algorithms Database System Concepts price total copies 84.66 74.99 Stochastic Calculus for Finance 1.02 Stochastic Calculus for Finance II 55.22 course title Algorithms DB Organizatio Advanced DB Organization Math Finance I Math Finance II courseid instructoridtextbookid enroll studentid courseid student faculty studentid namegpa Tom 3.3 John 3.8 Mary 3.0 Kris3.6 Alex 3.5 facultyid naime salarV James70000 Sarah 60000 Jay80000 Rachel 70000 Paul 85000 book checkout bookid studentid ate 2017-08-29 2017-09-02 2017-09-07 Hints:

Explanation / Answer

Thus this query will perform inner join between table book and table course with bookid and textbookid to be equal. Grouby statement with group the records having same textbookid and count(c.textbookid) >1 will output only those records which have textbookid for more than one course. This will output the desired result.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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