Crew Patient Compatibility Rule

Must have 1 pilot, 1 Flight Nurse, 1 Flight Paramedic or 1 Pilot and 2 Flight Nurses

CASE WHEN ((SELECT COUNT(*) FROM CREW WHERE Crew.Type = 'Pilot')=1 AND (SELECT COUNT(*) FROM CREW WHERE Crew.Type = 'Flight Nurse')=1
AND (SELECT COUNT(*) FROM crew WHERE Crew.Type = 'Flight Paramedic')=1) OR
((SELECT COUNT(*) FROM CREW WHERE Crew.Type = 'Pilot')=1 AND (SELECT COUNT(*) FROM Crew WHERE Crew.Type = 'Flight Nurse')=2)
THEN 1 ELSE END