Why using COUNT for the SELECT section?

Why use COUNT for the SELECT section? Below is the question and answer, but I am having a problem understanding why using COUNT in the SELECT.

All of the questions in this quiz refer to the open source Chinook Database. Please familiarize yourself with to familiarize yourself with the table and column names to write accurate queries and get the appropriate answers.

Run Query: Find all the tracks that have a length of 5,000,000 milliseconds or more.

SELECT COUNT(TrackId)

FROM Tracks

WHERE MIlliseconds > 5000000;

This is why I hate such courses. The wording sucks. It say "Find all tracks..." instead of "Count the number of...".

1 Like