CO19: Counts of condition occurrence records stratified by observation month

This query is used to count the condition occurrence records stratified by observation month. 

Input:
<None>

Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue
SELECT extract(month from condition_start_date) month_number,
       COUNT(*) as number_of_conditions_in_month
FROM   condition_occurrence 
GROUP BY extract(month from condition_start_date)
ORDER BY 1
Output:
Output field list:
 Field  Description
Month_number Month number
Number_of_conditions_in_month The number of the condition occurrences is a specified month.

Sample output record:
 Field  Description
Month_number  3
Number_of_conditions_in_month 20643257
Comments