The human resources manager wants to classify employees who were absent during the entire month as "inactive

Computer Science Oct 28, 2021

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.