Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Decision Making and Control

Authors: Jerold Zimmerman

8th edition

78025745, 978-0078025747

More Books

Students also viewed these Databases questions

Question

Leveraged buyouts? LO1

Answered: 1 week ago

Question

Describe three of Fechners psychophysical methods.

Answered: 1 week ago