You're given a dataset of health inspections. Count the number of violation in an inspection in 'Roxanne Cafe' for each year. If an inspection resulted in a violation, there will be a value in the 'violation_id' column. Output the number of violations by year in ascending order.
table name: sf_restaurant_health_violations
Solution:
select year(inspection_date), count(business_id) from
sf_restaurant_health_violations
where business_name='Roxanne Cafe' and violation_id is not null
group by year(inspection_date)
order by year(inspection_date)