How to set comparison query as a percentage?

Question

SQL

Tell me how to correctly compare SickLeaveHours > 20% VacationHours ,
SELECT LoginID
FROM HumanResources.Employee where (SickLeaveHours > 20*VacationHours) but it gives only 3 values ​​out of 1000, correct where the error is.

Answer 1

Your query will return records where SickLeaveHours is at least twenty times VacationHours.
It should be like this:

SELECT LoginID
FROM HumanResources.Employee 
WHERE (SickLeaveHours > 0.2*VacationHours)