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:

  SELECT AVG(Price) FROM Product