Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE ANSWER QUESTION A AND B 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
PLEASE ANSWER QUESTION A AND B
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started