MIS-610: QUERY SCENARIOS:

PROBLEM 3: Jo Berry's manager indicated that Jo was taking paid time off this month. He wants to ensure the system reflects this information. Import the "Hours" spreadsheet file into the AdventureWorks database. Add Jo Berry's hours together for the month, and title the field "Monthly Hours." Use the knowledge you have learned about NULL values to provide the solution to the manager.

PROBLEM 4: 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.

*** I have the answers for 3 and 4*** but I'm stuck on question 5

PROBLEM 5 Using the same parameters as Problem Four, rewrite the query to provide only the list of "Inactive" employees.