How do we count the number of records where the age field is less than 50?

SELECT COUNT(age) FROM people
WHERE age < 50;SELECT age FROM people
COUNT(age > 50);SELECT * FROM PEOPLE
WHERE age COUNT(age > 50);

Bingo! We want the number of records, not the records themselves, which is why we SELECT the countWHERE the condition age < 50 is true.

Hmm. We want the number of records, not the records themselves, which is why we SELECT the countWHERE the condition age < 50 is true.