MYSQL
THE TABLE IS HERE:
 

1. Write a query to get unique department ID from employee table. Excel file attached. 2. Write a query to get the details of all employees according to first name in descending order. 3. Write a query to get the names (first_name, last_name), salary, PF of all the employees (PF is calculated as 15% of salary). 4. Write a query to get the employee ID, name (first_name, last_name), salary in ascending order of salary. 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the maximum and minimum salary from employees table 7. Write a query to get the average salary and number of employees in the employees table. 8. Write a query to get the number of employees working with the company. 9. Write a query to get the number of designations available in the employees table. 10. Write a query get all first name from employees table in upper case.