Question

2. In a database there are two tables : Write MYSQL queries for (b) to (vi)
NoolOpdDays
Table: Doctors
DocID DocName
101 J K Mishra
102 Mahesh tripathi
103
Ravi Kumar
104
Mukesh Jain
Table Patients
Par No
PatName
1
Payal
2
Naveen
3
Rakesh
4
Atul
Department
Ortho
ENT
Neuro
Physio
3
4
5
3
Department
ENT
Ortho
Neuro
Physio
Docld
102
101
103
104
( To display PatNo, PatName and corr sponding DocName for each patient.
(m) To display the list of all doctors whose NoofOpdDays are more than 3.
(m) To display DocName, Department, PatName and DocId from both the tables
where DocID is either 101 or 103.​

Answer 1

Answer:

please follow me and like