Consider the following table: Emp_id Emp_name Job_name Manager_id Hire_date Salary 68319 66928 67832 64989 66564 KAYLING...

Transcribed Image Text:

Consider the following table: Emp_id Emp_name Job_name Manager_id Hire_date Salary 68319 66928 67832 64989 66564 KAYLING BLAZE CLARE ADELYN MADDEN PRESIDENT MANAGER ANALYST ANALYST SALESMAN 68319 65646 66928 66928 1991-11-18 6000.00 1991-05-01 2750.00 1997-04-19 3100.00 Commission Dep_id 1991-02-20 1700.00 400.00 1500.00 1991-09-28 1350.00 1001 3001 h. Write a query in SQL to list all the employees whose designation is CLERK i. Write a query in SQL to list the employees whose salaries are less than 3500 2001 3001 3001 Answer the following Queries a. Write a query in SQL to find the salaries of all employees b. Write a query in SQL to list the employees who does not belong to department 2001. c. Write a query in SQL to list the emp_id, salary, and commission of all the employees. d. Write a query in SQL to list the employees who joined before 1991 e. Write a query in SQL to display the average salaries of all the employees who works as ANALYST. f. Write a query in SQL to display the details of the employee BLAZE g. Write a query in SQL to display all the details of the employees whose commission is more than their salary. Consider the following table: Emp_id Emp_name Job_name Manager_id Hire_date Salary 68319 66928 67832 64989 66564 KAYLING BLAZE CLARE ADELYN MADDEN PRESIDENT MANAGER ANALYST ANALYST SALESMAN 68319 65646 66928 66928 1991-11-18 6000.00 1991-05-01 2750.00 1997-04-19 3100.00 Commission Dep_id 1991-02-20 1700.00 400.00 1500.00 1991-09-28 1350.00 1001 3001 h. Write a query in SQL to list all the employees whose designation is CLERK i. Write a query in SQL to list the employees whose salaries are less than 3500 2001 3001 3001 Answer the following Queries a. Write a query in SQL to find the salaries of all employees b. Write a query in SQL to list the employees who does not belong to department 2001. c. Write a query in SQL to list the emp_id, salary, and commission of all the employees. d. Write a query in SQL to list the employees who joined before 1991 e. Write a query in SQL to display the average salaries of all the employees who works as ANALYST. f. Write a query in SQL to display the details of the employee BLAZE g. Write a query in SQL to display all the details of the employees whose commission is more than their salary.

Answer rating: 100% (QA)

a b... View the full answer