Practice 5

Practice 5 - ASSIGNMENT FOR AST AND ANT JUNE 2004(29th july...

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

View Full Document Right Arrow Icon
ASSIGNMENT FOR AST AND ANT JUNE 2004(29th july 2004) Submission date: 30 th july 2004 Practice 5 Determine the validity of the following statements. Circle either True or False. 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 columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the decimal position. Save your SQL statement in a file called p5q4.sql . Maximum Minimum Sum Average ------- ------- ----- ------- 5000 800 29025 2073 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 CLERK 1300 800 4150 1038 MANAGER
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 2

Practice 5 - ASSIGNMENT FOR AST AND ANT JUNE 2004(29th july...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online