[SQL문제풀기] Number of violations

문제

StrataScratch - Number of violations

StrataScratch

https://platform.stratascratch.com/coding/9728-inspections-that-resulted-in-violations?code_type=7

내가 작성한 정답

MySQL

select year(inspection_date) year, count(distinct violation_id) 
from sf_restaurant_health_violations
where business_name = 'Roxanne Cafe'
group by year(inspection_date);

PostgreSQL

select extract(year from inspection_date) as year, count(distinct violation_id) 
from sf_restaurant_health_violations
where business_name = 'Roxanne Cafe'
group by extract(year from inspection_date);

Oracle

select to_number(to_char(inspection_date,'yyyy'),9999) year, count(distinct violation_id) 
from sf_restaurant_health_violations
where business_name = 'Roxanne Cafe'
group by to_number(to_char(inspection_date,'yyyy'),9999);