Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Step by Step Solution
★★★★★
3.47 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
a b...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started