Aggregate functions revisited


#1

Aggregate functions revisited

The first instruction reads:

The count function is an aggregate function, since it aggregates data from multiple rows.

Count the number of rows in the flights table, representing the total number of flights contained in the table.

As there are no conditions given, this should be a simple select count(*). However, that is flagged as incorrect, and the little response box does nothing to help.

What kind of response is expected?


Instructions
#2

The answer is so simple it's the example that throws you off. Throw the example away and just type:
SELECT COUNT(*) FROM flights;
(The COUNT will appear above the table.)


#3