the human resources manager wants to classify employees who were absent during the entire month as "inactive." using a case statement, write a query that classifies employees as "active" or "inactive"

the human resources manager wants to classify employees who were absent during the entire month as "inactive." using a case statement, write a query that classifies employees as "active" or "inactive" in a column titled "status" with "full name" (first and last) also listed. using the same parameters as problem four, rewrite the query to provide only the list of "inactive" employees.