I am trying to write a query that will give me the following:
# new patients in each of the years 1998 - 2003
Total # of patients of each status (active, inactive, expired) in each
of the years
All data is in one table, and the fields I need are: start date,
status, death date.
# new patients in each of the years 1998 - 2003
Total # of patients of each status (active, inactive, expired) in each
of the years
All data is in one table, and the fields I need are: start date,
status, death date.