Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.Use subqueries to list the surname of employees who have been on a course with employee 19. 2. List the surname of those who earn

image text in transcribed
1.Use subqueries to list the surname of employees who have been on a course with employee 19. 2. List the surname of those who earn less than the average salary of all staff 3. List the surname of employees who earn more than the average salary of employees who have jobs connected with Accounts 4. List the surname and forenames of employees who earn more than any employee connected to Admin. 5.List the surname and position of employees earning less than everyone in department 3 6. List the surname of employees who has been on a course which employee number 14 has not been on 7. List the surname of employees who are currently doing a unique job 8. List the surname of employees who have done or are doing any job which employee 23 has done or is doing. Include the surname of employee 23. 9. List the course names of courses which employees from department number 2 have been on 10. List the employee surname, forenames, and course for each time an employee attended a course at which no other colleague was present. 11. List the full names and positions of employees who have been on any of the courses that Robert Roberts has been on. Use subselect. 12. List the employee numbers and telephone numbers of all staff in department 3 or 1. Make use of UNION 13. List the employee number of the head of department 4 and the employee numbers of all staff in department 4 in a single table using union. 14. List the full name of everyone living in Edinburgh or who is in accounts. Perform this task using UNION 16 Write a query which shows which employee has had the most jobs with the company. There may be multiple employees with the biggest job count. Show the surname forename, and the job count in your answer. You will have to GROUP BY two columns (eg. GROUP BY XY)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

9th Edition

0135188148, 978-0135188149, 9781642087611

More Books

Students also viewed these Databases questions

Question

5. Discuss the key roles for training professionals.

Answered: 1 week ago