1. Write a query to list the number of jobs available in the employees table. From...

    

Transcribed Image Text:

1. Write a query to list the number of jobs available in the employees table. From attached Excel file. 2. Write a query to get the total salaries payable to employees. 3. Write a query to get the minimum salary from employees table. 4. Write a query to get the maximum salary of an employee working as a Programmer. 5. Write a query to get the highest, lowest, sum, and average salary of all employees. 6. Write a query to get the number of employees with the same job. 7. Write a query to get the difference between the highest and lowest salaries. 8. Write a query to get the department ID and the total salary payable in each department. 9. Write a query to get the average salary for each job ID excluding programmer. 10. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID ), for department ID 90 only. 1. Write a query to list the number of jobs available in the employees table. From attached Excel file. 2. Write a query to get the total salaries payable to employees. 3. Write a query to get the minimum salary from employees table. 4. Write a query to get the maximum salary of an employee working as a Programmer. 5. Write a query to get the highest, lowest, sum, and average salary of all employees. 6. Write a query to get the number of employees with the same job. 7. Write a query to get the difference between the highest and lowest salaries. 8. Write a query to get the department ID and the total salary payable in each department. 9. Write a query to get the average salary for each job ID excluding programmer. 10. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID ), for department ID 90 only.

Answer rating: 100% (QA)

1First you need import the excel to your Database table I have created below CREATE TABLE employees ... View the full answer