How many employees have salary greater than 70000 but fail the inspection?
salary greater than 70000 refers to salary > 70000; fail the inspection refers to results = 'Fail'
SELECT COUNT(DISTINCT T1.employee_id) FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T2.results = 'Fail' AND T1.salary > 70000