Write SQL queries for TRAINERTIDTNAMECITYHIREDATESALARY101SUNAINA MU

1.	Write SQL queries for TRAINERTIDTNAMECITYHIREDATESALARY101SUNAINA MUMBAI1998-10-1590000102ANAMIKADELH1994-12-2480000103DEEPTICHANDIGARG2001-12-21 82000104MEENAKSHI DELHI2002-12-25 78000105RICHAMUMBAI 1996-01-1295000106MANIPRABHACHENNAI2001-12-1269000COURSECIDCNAMEFEESSTARTDATETIDC201AGDCA120002018-07-02101C202ADCA150002018-07-15103C203DCA100002018-10-01102C204DDTP90002018-09-15 104C205DHN200002018-08-01101C206O LEVEL180002018-7-25105(i) To display the TNAME and CITY of Trainer who joined the Institute in the month of December 2001.(ii) To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.
Answer» (i) SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE BETWEEN ‘2001-12-01’ AND ‘2001-12-31’; OR SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE >= ‘2001-12-01’ AND HIREDATE<=‘2001-12-31’; OR SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE LIKE ‘2001-12%’; (ii) SELECT TNAME,HIREDATE,CNAME,STARTDATE FROM TRAINER, COURSE WHERE TRAINER.TID=COURSE.TID AND FEES<=10000;

Write SQL queries for TRAINERTIDTNAMECITYHIREDATESALARY101SUNAINA MUMBAI1998-10-1590000102ANAMIKADELH1994-12-2480000103DEEPTICHANDIGARG2001-12-21 82000104MEENAKSHI DELHI2002-12-25 78000105RICHAMUMBAI 1996-01-1295000106MANIPRABHACHENNAI2001-12-1269000COURSECIDCNAMEFEESSTARTDATETIDC201AGDCA120002018-07-02101C202ADCA150002018-07-15103C203DCA100002018-10-01102C204DDTP90002018-09-15 104C205DHN200002018-08-01101C206O LEVEL180002018-7-25105(i) To display the TNAME and CITY of Trainer who joined the Institute in the month of December 2001.(ii) To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.

Answer»

(i) SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE BETWEEN ‘2001-12-01’ AND ‘2001-12-31’; OR

SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE >= ‘2001-12-01’ AND HIREDATE<=‘2001-12-31’;

SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE LIKE ‘2001-12%’;

(ii) SELECT TNAME,HIREDATE,CNAME,STARTDATE FROM TRAINER, COURSE WHERE TRAINER.TID=COURSE.TID AND FEES<=10000;