Does this query give us the number of rows in a table?

No, because COUNT() is missing the *Yes

No, because COUNT() is missing the *.