Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CAN ANYONE PLEASE HELP TO ANSWER QUESTION C PATIENT (patient_id, patient_name, age, address, sex, phone, doctor_id, hospital id) DOCTOR(doctor_id, doctor_name, specialize, salary) HOSPITAL (hospital_id, hospital_name)

image text in transcribed

CAN ANYONE PLEASE HELP TO ANSWER QUESTION C

PATIENT (patient_id, patient_name, age, address, sex, phone, doctor_id, hospital id) DOCTOR(doctor_id, doctor_name, specialize, salary) HOSPITAL (hospital_id, hospital_name) Statement 1 / Pernyataan 1 2. Write the SQL query to answer the following questions base on statement 1 above. a. Retrieve the name and address of patients who live in Melaka. (3) b. Retrieve the information of all doctors who can treat "Neuro" problem and who earn more than RM65, 000. c. Retrieve the name, sex and age of every patient at "Melaka General" hospital. (5) d. Retrieve the name, age and phone number of every Male patient. (3) e. Retrieve the name of every doctor ever treated patient older than 65. (5) (Total: 20)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions