Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (vii), which are based on the tables.
Table: Trainer
| TID |
Tname |
City |
HireDate |
Salary |
| 101 |
Sunaina |
Mumbai |
1998-10-15 |
90000 |
| 102 |
Anamika |
Delhi |
1994-12-24 |
80000 |
| 103 |
Deepti |
Chandigarh |
2001-12-21 |
82000 |
| 104 |
Meenakshi |
Delhi |
2002-12-25 |
78000 |
| 105 |
Richa |
Mumbai |
1996-01-12 |
95000 |
| 106 |
Maniprabha |
Chennai |
2001-12-12 |
69000 |
Table: Course
| CID |
CNAME |
FEES |
STARTDATE |
TID |
| C201 |
AGDCA |
12000 |
2018-07-02 |
101 |
| C202 |
ADCA |
15000 |
2018-07-15 |
103 |
| C203 |
DCA |
10000 |
2018-10-01 |
102 |
| C203 |
DDTP |
9000 |
2018-09-15 |
104 |
| C205 |
DHN |
20000 |
2018-08-01 |
101 |
| C206 |
O LEVEL |
18000 |
2018-07-25 |
105 |
(a) Display the Trainer Name, City and Salary in descending order of their hire date.
(b) To display the TNAME and CITY of Trainer of joined the institute in the month of December 2001.
(c) To display TNAME, HIREDATE,CNAME, STARTDATE from tables TRAINER and COURSE whose FEES is less than or equal to 10000
(d) To display number of trainer from each city
(e) select tid, tname,from trainer where city not in(‘delhi’,’mumbai’);
(f) select distinct tid from course;
(g) select tid , count (*), min(fees) from course group by tid having count(*)>1;
(h) Select count(*),sum(fees) from course where startdate <’2018-09-15’;