Task8_Available Mechanics_Exam_27June2020

-- Task 8 Available Mechanics
SELECT CONCAT(m.FirstName, ' ', m.LastName) AS Available
    FROM Mechanics AS m
    LEFT JOIN Jobs AS j ON j.MechanicId = m.MechanicId
    WHERE j.[Status] LIKE 'Finished' OR j.[Status] IS NULL
    GROUP BY m.MechanicId, m.FirstName, m.LastName
    ORDER BY m.MechanicId ASC