Cases by year

Custom SQL query returning 78 rows (hide)

SELECT year, COUNT(*) AS n
FROM cases
WHERE year IS NOT NULL
  AND year >= CAST(COALESCE(NULLIF(:start_year, ''), '1349') AS INTEGER)
  AND year <= CAST(COALESCE(NULLIF(:end_year, ''), '1596') AS INTEGER)
GROUP BY year
ORDER BY year

Query parameters

start_year

end_year

Edit SQL