SQL Summary Statistics Missing Values

Screen Link:

Computing SQL Summary Statistics | Dataquest

My Code:

SELECT COUNT (*), COUNT(Unemployment_rate)
FROM recent_grads;

What I expected to happen:

[1 rows x 2 columns]
COUNT (*)       COUNT(Unemployment_rate)
173                   172

What actually happened:

[1 rows x 2 columns]
COUNT (*)       COUNT(Unemployment_rate)
173                   172

I don’t see anything at all different between my answer and the correct answer, but I continue to receive the message, “The value for result doesn’t look right.”

Hi @thatjasonweaver,

Welcome to the Community!

You should remove the white space between the first COUNT and the bracket, and your code will work correctly.

I did as you suggested, and it worked! Thanks a bunch!!

1 Like