Forum

SQL Query Suzy is a...
 
Notifications
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: 1 year ago

Query:

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.

Instructions

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

Tables:

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: 1 year 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');
Reply
Share: