Among the employees in Adventure Works, calculate the percentage of them working as sales representatives.
percentage of sales representatives = divide(count(JobTitle = 'Sales Representative'), count(JobTitle))*100%
SELECT CAST(SUM(CASE WHEN JobTitle = 'Sales Representative' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(BusinessEntityID) FROM Employee