Most Common Names by Year and Gender

Custom SQL query (hide)

SELECT name, SUM(count) AS count, gender FROM first_names
 WHERE year = :year
   AND position = 1
   AND gender LIKE IFNULL(NULLIF(:gender, ""), "%")
GROUP BY name
ORDER BY count DESC

Query parameters

gender

year

Edit SQL