How many inspections failed in 2014?
failed refers to results = 'Fail'; in 2014 refers to inspection_date like '2014%'
SELECT COUNT(inspection_id) FROM inspection WHERE strftime('%Y', inspection_date) = '2014' AND results = 'Fail'