CO20: Counts of stop reasons

This query is used to count stop reasons (stop_reason) across all condition occurrence records. 

Input:
<None>

Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue
SELECT COUNT(stop_reason) AS stop_reason_count,
       stop_reason
FROM   condition_occurrence 
GROUP BY stop_reason
Output:
Output field list:
 Field  Description
stop_reason_count The number of the condition occurrences with a specific stop reason.
 stop_reason Reason for condition stop

Sample output record:
 Field  Description
stop_reason_count  20100
stop_reason resolved
Comments