fagreg zad, TIN inż, Semestr 6, Bazy danych 2, Laboratorium
[ Pobierz całość w formacie PDF ]
1. Group functions work across many rows to produce one result per group.
True/False
2. Group functions include nulls in calculations.
True/False
3. The WHERE clause restricts rows prior to inclusion in a group calculation.
True/False
4. Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum,
Sum, and Average, respectively. Round your results to the nearest whole number.
6. Write a query to display the number of people with the same job.
8. Write a query that displays the difference between the highest and lowest salaries. Label the column
DIFFERENCE.
9. Display the manager number and the salary of the lowest paid employee for that manager. Exclude anyone whose
manager is not known. Exclude any groups where the minimum salary is less than $6,000. Sort the output in
descending order of salary.
13. Displays the number of employees in department 50.
16. Display the number of distinct department values in the EMPLOYEES table.
19. Display of average salaries of those departments that have an average salary greater than $8,000
[ Pobierz całość w formacie PDF ]