Question

Write SQL queries for (i) to (iv) , which are the based on the tables : TRAINER and COURSE given
(i) Display the Trainer Name, City & Salary in descending order of their Hiredate.
(ii) To display the TNAME and CITY of trainer who joined the institute in the month of December 2001.
(iii) To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.
(iv) To display number of trainers from each city.​

Answer 1

Explanation:

writen all 4 expected select queries