Question

Observe the following table
HOSPITAL:
No
1
2
3
4
5
Name
Arpit
Zarina
Kareen
Arun
Zubin
Kerald
Ankita
Zareen
Kush
Shilpa
Age
62
42
32
52
60
36
29
45
29
43
Dept
Surgeon
ENT
Orthopedic
Surgeon
ENT
ENT
Cardiology
Gynecology
Cardiology
Orthopedic
DOJ
1998-02-21
1997-12-12
1999-02-19
2000-03-21
2005-12-03
2010-05-04
2011-12-11
2007-10-24
2003-07-14
2012-03-04
Charges Sex
300 M
400 F
200
M
600
M
NULL M
550
F
200
F
250 F
NULL M
500
F
6
7
8
9
10
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.
(f) To display the detail of all the
doctors whose age is less than 50
years.​

Answer 1

Answer:

Observe the following table HOSPITAL: No 1 2 3 4 5. Name Arpit Zarina Kareen Arun Zubin Kerald Ankita Zareen Kush Shilpa Age 62 42 32 52 60 36 29 45 29 43.