Top surnames

Custom SQL query returning 40 rows (hide)

SELECT n.surname, COUNT(*) AS n
FROM names n
JOIN cases c ON c.id = n.case_id
WHERE c.year IS NOT NULL
  AND c.year >= CAST(COALESCE(NULLIF(:start_year, ''), '1349') AS INTEGER)
  AND c.year <= CAST(COALESCE(NULLIF(:end_year, ''), '1596') AS INTEGER)
GROUP BY n.surname
ORDER BY n DESC
LIMIT 40

Query parameters

start_year

end_year

Edit SQL