Scribd
Upload
2 views1 page

Themepark Employee and Income Analysis

Uploaded by

Phương Nguyễn Mai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

Themepark Employee and Income Analysis

Uploaded by

Phương Nguyễn Mai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Write sql statements to return the following information

1. Total lines for each transaction


2. Total employee of each themepark
3. Total themepark for each employee.
4. Display employee fullname, attraction name, themepark name, country and city of all
themepark they have worked
5. For each themepark, display themepark name, city, and its total income.
6. Display total income for each type of ticket.
7. Find the total working hours for each employee in attraction 10034
8. Find the average working hours for each attraction
9. Find average ticket price for each themepark
10. show the total working hours for each employee in attraction 10034 with total working hours >
7
11. display employee first name, lastname, total working hours with condition that total working
hours must be >7. order the result by firstname

Subquerries

1. Details of the themeparks with the fewest employees.


2. Details of employees who work the most time.
3. Details of employees who get the highest total salary.

You might also like