Cacher is the code snippet organizer for pro developers

SELECT unit_id,
  COUNT(np_time_code) as NP_COUNT
FROM Unit_Np_Time
WHERE unit_id IN
  ( SELECT DISTINCT unit_id 
    FROM Unit_Spec 
    WHERE Unit_Spec.Facility_Id = 'HH'
  )
GROUP BY unit_id
ORDER BY NP_COUNT ASC, UNIT_ID;