# Practice5 - Practice 5 SQL 1. Group functions work across...

This preview shows pages 1–2. Sign up to view the full content.

Practice 5 – SQL 1. Group functions work across many rows to produce one result. 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 column Maximum, Minimum, Sum, and Average, respectively. Round your results to the decimal position. Save your SQL statement in a file called p5q4.sql 5. Modify p5q4.sql to display the minimum, maximum, sum and average salary for each job type. Resave to a file called p5q5.sql. Rerun your query. JOB Maximum Minimum Sum average -------- ------------- ------------- ------ ----------- ANALYST 3000 3000 6000 3000 6. Write a query to display the number of people with the same job JOB COUNT(*) ------------ -------------- ANALYST 2 7. Determine the number of managers without listing them. Label the column Number of Managers. Number of Managers

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/29/2012 for the course INTERNATIO 101 taught by Professor Mr.johnnash during the Spring '11 term at Symbiosis International University.

### Page1 / 2

Practice5 - Practice 5 SQL 1. Group functions work across...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online