Metropolitan Museum of Art - Step 2

Hi, I had a general query question on this step. Here is what I typed:

SELECT COUNT(*)
FROM met;

The return was 3948.

When I write out the original selection command:

SELECT *
FROM met;

It clearly returns 4257 rows:

I have not added an argument to this aggregate function so I figured it would return every row. Am I missing something obvious or is it a limitation of what the project wants you to count? I originally thought to write it out this way because I felt that with so many rows it would be better to be specific. I was not sure if there was more than one department.

Screen Shot 2020-07-24 at 9.57.32 AM

Anyway, any clarification would be appreciated.

Thank you in advance,
William

This is working and counting correctly. If we run

 SELECT *
 FROM met
 LIMIT 20;

Then we see that the id’s listed go from 1-38. This is because looking at it, there are no rows with id 15-32. Therefore it is safe to assume that the id isn’t a consistent count and the MAX(id) being 4257 is not indicative of the number of rows in the database.

2 Likes