SQL Query The Hospital has found a Replacement, a Patient named Hetty.

Last Post

Posts: 1

I Yamaly

Guest

Topic starter

Aug 11, 2020 12:46 pm

(@I Yamaly)

New Member

Joined: 3 years ago

Query:

The hospital has found a replacement, a patient named Hetty. Change the appointment date of Hetty to that of Suzy's appointment date.

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 2 years ago 2 times by KV Kumar

Topic Tags

1 Reply

Posts: 18

A Sharma

Guest

Aug 11, 2020 2:19 pm

(@A Sharma)

Active Member

Joined: 3 years ago

Here is the query to achieve the expected results.

Update Patient
Set nextApptDate = decode(patName, 'Suzy',
(Select nextApptDate from patient where patName = 'Hetty'),
'Hetty',
(Select nextApptDate from patient where patName = 'Suzy'))

Where patName in ('Suzy', 'Hetty');

This post was modified 2 years ago by KV Kumar