Question

Can someone help me with the SQL for these queries
*Display the patient names staying in noida
*Display the patient names whose names are starting with 'm'
*Display the doctors whose fee is between 1500and 2500
*Display the doctors name whose fee is not yet entered(null)
*Display the patient names and their respective doctors names from both the tables

The table names are Table-Patient and Table-Doctor

Answer 1

Answer:

Explanation:

1) select patient_name from patient where city='noida';

2) select patient_name from patient where patient_name like 'm%';

3) select doctor_name from doctor where fee between 1500 and 2500;

4)select doctor_name from doctor where fee=NULL;

5)select patient_name,doctor_name from patient,doctor where patient.pid=doctor.pid;

*note- i dont the column names, q5 can only be possible if you implement a foreign key