-- Database schema
| employee : employee_id [ INTEGER ] primary_key , first_name [ TEXT ] , last_name [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ INTEGER ] , phone [ TEXT ] , title [ TEXT ] , salary [ INTEGER ] , supervisor [ INTEGER ] employee.supervisor = employee.employee_id | establishment : license_no [ INTEGER ] primary_key , dba_name [ TEXT ] , aka_name [ TEXT ] , facility_type [ TEXT ] , risk_level [ INTEGER ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ INTEGER ] , latitude [ REAL ] , longitude [ REAL ] , ward [ INTEGER ] | inspection : inspection_id [ INTEGER ] primary_key , inspection_date [ DATE ] , inspection_type [ TEXT ] , results [ TEXT ] , employee_id [ INTEGER ] inspection.employee_id = employee.employee_id , license_no [ INTEGER ] inspection.license_no = establishment.license_no , followup_to [ INTEGER ] inspection.followup_to = inspection.inspection_id | inspection_point : point_id [ INTEGER ] primary_key , Description [ TEXT ] , category [ TEXT ] , code [ TEXT ] , fine [ INTEGER ] , point_level [ TEXT ] | violation : inspection_id [ INTEGER ] violation.inspection_id = inspection.inspection_id , point_id [ INTEGER ] violation.point_id = inspection_point.point_id , fine [ INTEGER ] , inspector_comment [ TEXT ] |
-- -- How many inspections were sanitarian Joshua Rosa responsible for in 2010?

SELECT COUNT(T2.inspection_id) FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE strftime('%Y', T2.inspection_date) = '2010' AND T1.first_name = 'Joshua' AND T1.last_name = 'Rosa';