counting up who has nonmissing HADM and ICUSTAY
2176 distinct SUB-HAD-ICU have trop over 1
final pair of counts before simplifying
Simplified to a Trop query that actually pulls SUBJECT, HADM, and ICUSTAY.