Page 72 - IP
P. 72
(1) To display name of all doctors who are in Medicine having more than 10 years of experience. (2) To
display the different departments.
(3) To display minimum consultation fee of female doctors
(4) To display name and department of male doctors who has no experience. (5) SELECT AVG(ConstFee)
FROM Doctor WHERE NOT Gender=’F’; (6) SELECT Count(Experience) FROM Doctor;
(7) SELECT Name, Experience FROM Doctor WHERE id BETWEEN 100 AND 200; (8) SELECT
SUM(ConstFee),MAX( Experience) FROM Doctor;
6.(a) Write MySql Command to create the Table “Hotel” with the following structure: 2
Table: Hotel
Field Name Field Type Constraint
Room_No Integer(3) Primary Key
Type Varchar(20)
Fare Integer(4) Not Null
Floor Varchar(10)
(b) In a database, there are two table “Company” and “Model” as shown below: Company
CompID CompName CompHO Cont Person
1 Titan Okhla BC.Joshi
2 Ajanta Najafgarh V.P.Gupta
3 Maxima Shahdara R.Kumar
Model
