This query is used to provide summary statistics for the number of drug exposure records (drug_exposure_id) for all persons: the mean, the standard deviation, the minimum, the 25th percentile, the median, the 75th percentile, the maximum and the number of missing values. There is no input required for this query.
Input:
<None>
Sample query run:
The following is a sample run of the query.
-- Oracle
SELECT min(tt.stat_value) AS min_value
, max(tt.stat_value) AS max_value
, avg(tt.stat_value) AS avg_value
, (round(stdDev(tt.stat_value)) ) AS stdDev_value
, PERCENTILE_DISC(0.25) WITHIN GROUP( ORDER BY tt.stat_value )
AS percentile_25
, PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY tt.stat_value )
AS median_value
, PERCENTILE_DISC(0.75) WITHIN GROUP (ORDER BY tt.stat_value )
AS percential_75
FROM
( SELECT count(1) AS stat_value
FROM drug_exposure t
group by t.person_id
) tt
;
Output:
Output field list:
| Field |
Description |
| drug_exposure_id |
A system-generated unique identifier for each drug utilization event. |
| person_id |
A foreign key identifier to the person who is subjected to the drug. The demographic details of that person are stored in the person table. |
| count |
The number of individual drug exposure occurrences used to construct the drug era. |
| percentile_25_date |
|
| median_date |
|
| percentile_75_date |
|
Sample output record:
| Field |
Description |
| drug_exposure_id |
|
| person_id |
|
| count |
|
| percentile_25_date |
|
| median_date |
|
| percentile_75_date |
|
| 