Question

Observe the following table HOSPITAL:
No Name
Age Dept
1 Arpit 62 Surgeon
2 Zarina 42
ENT
3 Kareen 32 Orthopedic
52 Surgeon
5 Zubin 60
ENT
6 Ketaki 36
ENT
7 Ankita 29 Cardiology
8 Zareen 45 Gynecology
9 Kush 29 Cardiology
Shilpa
Orthopedic
M
ܚܙܐ ܕܫ
DO Chases
1998-02-21 300
1997-12-12 400
1999-02-19 200
2000-03-21
2005-12-03 NULL
2010-05-04
2011-12-11
2007-10-24 250
2003-07-14 NULL
2012-03-04 500
>
F
F
F
Write Queries:
(a) Write command to create the table HOSPITAL
(b) To display the detail of all the surgeons.
(c) To display the detail of all the Females.
(d) To display the name of the all the ENT doctors.
(e) To display the name and Dept of those doctors whose charges are more than 500.
(1) To display the detail of all the doctors whose age is less than 50 years.​

Answer 1

Answer:

Age Dept 1 Arpit 62 Surgeon 2 Zarina 42. ENT 3 Kareen 32 Orthopedic 52 Surgeon 5 Zubin 60. ENT 6 Ketaki 36. ENT 7 Ankita 29 .