Participants (pID, role, lname, fname, affiliation, email, lunch) Talks (tID, pID, title, topic, abstract, sID) Sessions (sID,
Fantastic news! We've Found the answer you've been seeking!
Question:
Participants (pID, role, lname, fname, affiliation, email, lunch)
Talks (tID, pID, title, topic, abstract, sID)
Sessions (sID, description, topic, room, start, stop, mID)
Write an SQL query which returns any session that is overloaded, I need to verify that the overload session is the last session of the day for that topic, just return the sID, topic, room, start time , and the actual number of presentations in the session for all overloaded sessions.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: