Homework answers / question archive / 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

Computer Science

Share With

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.