Counts the year of birth (year_of_birth) across all person records. All existing values for year of birth are summarized.
Input:
<None>
Sample query run:
The following is a sample run of the query.
SELECT year_of_birth,
COUNT(person_id) AS Num_Persons_count
FROM person
GROUP BY year_of_birth
ORDER BY year_of_birth
Output:
Output field list:
Field |
Description |
year_of_birth |
Year of birth of the patient |
Num_Persons_count |
Number of patients in the dataset of specific year of birth |
Sample output record:
Field |
Value |
year_of_birth |
1950 |
Num_Persons_count |
389019 |
|