Usage by Name at a Given Position 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, ""), "%")
   AND position = :position
GROUP BY year, gender
ORDER BY year ASC

Query parameters

gender

name

position

Edit SQL