previous
|
start
|
next
Calculations
Use the count function to find out how many customers there are in California
SELECT COUNT(*) FROM Customer WHERE State = 'CA'
The * means you want to calculate whole records
Other functions are SUM, AVG, MAX, MIN
These functions must access a specific column. Put the column name in parentheses
SELECT AVG(Price) FROM Product
previous
|
start
|
next