SQL practice exercises Worker WOBRE 001 Monika Arora 002 Niharika Verma 003 Vishal Singhal 004 Amitabh Singh 005 Vivek Bhati 066 Vipul Diwan 007 Satish Kumar 008 Geetika Chauhan 100000 80000 300000 S00000 500000 200000 75000 90000 2014-02-20 09:00:00 2014-06-11 09:00:00 2014-02-20 09:00:00 2014-02-20 09.00.00 2014-06-11 09:00:00 2014-06-11 09:00:00 2014-01-20 09:00:00 2014-04-11 09:00:00 HR Admin HR Admin Admin Account Account Admin Bonus WORKEURIGO 1 2 3 1 2 RONJATE 2016-02-20 00:00:00 2016-06-11 00:00:00 2016-02-20 00:00:00 2016-02-20 00:00:00 2016-06-11 00:00:00 KONGS AROUND S000 9000 4000 4500 3500 Title MOLEKULTJO WORKER_TITLE AFTECTED FROM Manager 2016-02-20 00:00:00 2 Executive 2016-06-11 00:00:00 Executive 2016-06-11 00:00:00 5 Manager 2016-06-11 00:00:00 4 Asst. Manager 2016-06-11 00:00:00 Executive 2016-06-11 00:00:00 Lead 2016-06-11 00:00:00 Lead 2016-06-11 00:00:00 a) Write SOL command to create all the three tables shown above, Workder Ref ID refers to worker ID (3 39 Marks) b) Insert first two records to worker table (2 Marks) c) Write an SQL query to fetch unique values of DEPARTMENT from Worker table. (2 Marks) d Write an SQL query to print all Worker details from the Worker table order by FIRST NAME Ascending and DEPARTMENT Descending (2 Marks) e) Write an SOL query to print details for Workers with the first name as "Vipul" and "Satish from Worker table. (2 Marks) 1) Write an SQL query to print details of Workers with DEPARTMENT name as "Admin. (2 Marks) Continued... g) Write an SQL query to print details of the Workers whose FIRST_NAME ends with a' (2 Marks) h) Write an SQL query to print details of the Workers whose SALARY lies between 100000 and 500000 (2 Marks) i) Write an SQL query to print details of the Workers who have joined in Feb 2014. (2 Marks) Note: For the joing_date, bonus_date and affected_from attributes use date as the data type. Describe each table as PROOF