SELECT 
    "year",
    COUNT("case") AS total_cases
FROM 
    @kaggle.ibriiee_tesla_autonomous_deaths_data_updated_2023.tesla_deaths_deaths
WHERE 
    "year" IS NOT NULL
    AND "year" BETWEEN 2013 AND 2023
GROUP BY 
    "year"
ORDER BY 
    "year" ASC;