PSQL query

Please explain thank you!!

Connect to the world database. Query the city table. Part 1) Write a query to sum up city populations and organize rows by the 2nd letter of the city's country code. Include a count of countries represented by each row. Label results to exactly match the below query: There are 26 letters in the alphabet. Why does this query not return 26 rows