TASK 2: QUERIES USING DML & DQL COMMANDS
• CREATE A TABLE FOR EMPLOYEE WITH THESE DETAILS.
emp_id | emp_name | job_name | manager_id | hire_date | salary | commission
| dep_id
--------+----------+-----------+------------+------------+---------
+------------+--------
68319 | KAYLING | PRESIDENT | | 1991-11-18 | 6000.00 | | 1001
66928 | BLAZE | MANAGER | 68319 | 1991-05-01 | 2750.00 | | 3001
67832 | CLARE | MANAGER | 68319 | 1991-06-09 | 2550.00 | | 1001
65646 | JONAS | MANAGER | 68319 | 1991-04-02 | 2957.00 | | 2001
67858 | SCARLET | ANALYST | 65646 | 1997-04-19 | 3100.00 | | 2001
69062 | FRANK | ANALYST | 65646 | 1991-12-03 | 3100.00 | | 2001
63679 | SANDRINE | CLERK | 69062 | 1990-12-18 | 900.00 | | 2001
64989 | ADELYN | SALESMAN | 66928 | 1991-02-20 | 1700.00|400.00 |
3001
65271 | WADE | SALESMAN | 66928 | 1991-02-22 | 1350.00 |
600.00 | 3001
66564 | MADDEN | SALESMAN | 66928 | 1991-09-28 | 1350.00 |
1500.00 | 3001
68454 | TUCKER | SALESMAN | 66928 | 1991-09-08 | 1600.00 |
0.00 | 3001
68736 | ADNRES | CLERK | 67858 | 1997-05-23 | 1200.00 |
| 2001
69000 | JULIUS | CLERK | 66928 | 1991-12-03 | 1050.00 |
| 3001
69324 | MARKER | CLERK | 67832 | 1992-01-23 | 1400.00 |
| 1001
2. Write a SQL query to update the salary Frank to 4500.
3. Write a SQL query to update the salaries of all employees individually by adding an increment of Rs.1000
4. Write a SQL query to increase the salaries of all employees by 20%
5. Write a SQL query to delete the record of the president from the Employee Table.
6. Write a SQL query to delete all the records from Employee table.
7. Write a SQL query to display the names of all Employees
8. Write a SQL query to display the details of all Employees
9. Write a SQL query to display the distinct designations of all Employees
10. Write a SQL query to list the employee's name and job name as a format of "Employee & Job".
11. Write a SQL query to display those employees with hire date between 01.01.1991 and 31.12.1991. Return
employee ID, employee name, salary, hire date.
12. Write a SQL query to display the names of all Employees where dep_id is 1001 and 3001.
13. Write a SQL query to display the names of all Employees which begin with ‘J’.
14. Write a SQL query to display the names of all Employees which begin with ‘M’ and end with ‘R’.
15. Write a SQL query to display the names of all Employees which begin with ‘J’ and end with ‘S’ and contains
exactly 5 characters.
