SQL Query List names of patients who live in Petaling Jaya, Subang Jaya, Shah Alam and Klang cities

Last Post

RSS

Posts: 1

I Yamaly

Guest

Topic starter

Aug 11, 2020 12:36 pm

(@I Yamaly)

New Member

Joined: 4 years ago

Query:

List names of patients who live in Petaling Jaya, Subang Jaya, Shah Alam and Klang cities, names of their doctors and the patients' balances where the due date is on '30-Jun-2020'

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:14 pm

(@A Sharma)

Active Member

Joined: 4 years ago

Here is the query to find Names of patients who live in Petaling Jaya, Subang Jaya, Shah Alam and Klang cities, names of their doctors and the patients' balances where the due date is on '30-Jun-2020'

Select p.patientName
From patient p, billing b
Where p.patID = b.patID
And b.city in ('Petaling Jaya', 'Subang Jaya', 'Shah Alam', 'Klang')
And trunc(b.dueDate) = '30-JUN-2020';

This post was modified 3 years ago by KV Kumar