SQL Functions   «Prev 

SQL Numeric Functions - Exercise

Numeric functions

Objective: Write a query that uses several numeric functions.
Assume you have a table named MyTable that contains both a Sales and a State column. Create a statement that will return the minimum, maximum, total, and average values for the Sales column. Be sure to name the columns Minimum, Maximum, Total, and Average, respectively. Only show those sales figures that are in California (CA).