Usage by Name over Time, Sorted by Year

Custom SQL query (hide)

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

Query parameters

gender

name

Edit SQL