SQL to get counts by statuses and completeness Recently I came across a need to get the counts of result by statuses as well as completeness – i.e. getting positive result (pass) in all cases. I quickly