$--$ Query $5$

SELECT

CASE

WHEN GroupID IS NULL THEN 'NoGroup'

ELSE 'InAGroup'

END AS Grouping,

COUNT$(*)$ AS NumInGroup

FROM ManifestPassenger

WHERE PassID IN $($SELECT PassID FROM Passenger WHERE IsTest $=1)$

GROUP BY GroupID IS NULL

ORDER BY NumInGroup;