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

Last Post

RSS

Posts: 1

I Yamaly

Guest

Topic starter

Aug 11, 2020 12:40 pm

(@I Yamaly)

New Member

Joined: 4 years 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)

This topic was modified 3 years ago by KV Kumar

Topic Tags

1 Reply

Posts: 18

A Sharma

Guest

Aug 11, 2020 2:17 pm

(@A Sharma)

Active Member

Joined: 4 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');

This post was modified 3 years ago by KV Kumar