Database: apartment_rentals
Question: Sort the gender codes in descending order of their corresponding number of guests. Return both the gender codes and counts.
SQL:
SELECT gender_code ,  COUNT(*) FROM Guests GROUP BY gender_code ORDER BY COUNT(*) DESC