OP17: Counts of observation period records stratified by observation end date month

This query is used to count the observation period records stratified by observation month and person end. person end is an indicator whether a person has completed the last observation period in a given observation month. All possible values are summarized.

Input:

Sample query run:
The following is a sample run of the query.
SELECT EXTRACT( month FROM observation_period_end_date ) observation_month
     , count(*) AS num_observations
  FROM observation_period
GROUP BY EXTRACT( month FROM observation_period_end_date )
ORDER BY 1
Output:
Output field list:
 Field  Description
observation_month Month of observation
num_observations Number of observation within end of observation period month

Sample output record:
 Field  Description
observation_month  1
num_observations  62183
Comments