SQL Query Suzy is a...
Clear all

SQL Query Suzy is a patient of Dr. Rahim. She has cancelled her next Appointment

I Yamaly
Posts: 1
 I Yamaly
Topic starter
(@I Yamaly)
Joined: 2 years ago


Suzy is a patient of Dr. Rahim. She has canceled her next appointment with Dr. Rahim. Find other patients of Dr. Rahim ( do not include Suzy in the result and show all their details) whose next appointments are after Suzy's appointment so that the hospital may find a replacement.


The following relational schema forms part of a hospital database. The primary keys are underlined and foreign keys are in italics.


Doctor (docID, docName, dateHired, monthlySalary, area, chargePerAppt, annualBonus)
Patient (patID, patName, dateOfBirth, nextAppDate, lastAppDate, docID)
Billing (patID, balance, due date, phone, address, city, street, postcode, insurance)



1 Reply
A Sharma
Posts: 18
 A Sharma
(@A Sharma)
Joined: 2 years ago

Here is the query to achieve this requirement. 

select p.*
From patient p, doctor d
Where d.docID = p.docID
And p.patName <> 'Suzy'
And d.docName = 'Dr. Rahim'
And p.nextApptDate > ( select nextApptDate from patient
Where patName = 'Suzy');

Leave a reply

Author Name

Author Email

Title *

Preview 0 Revisions Saved