Busiest places

Custom SQL query returning 40 rows (hide)

SELECT p.place_name, p.county, COUNT(*) AS n
FROM names n
JOIN places p ON p.id = n.place_id
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 p.id
ORDER BY n DESC
LIMIT 40

Query parameters

start_year

end_year

Edit SQL