The human resources manager wants to classify employees who were absent during the entire month as 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.