Dear Sirs et Madames,
I have a source table which has the following columns:
I need to create a view with three columns:
the age range column should contain the values 0-4,5-9,10-14,15-19,...,85+ in those intervals until the last row should read 85+ in the age_range column ( so in total I will have 23 rows in this view).
The number_of_males column should contain the count of the number of males who fit in the corresponding age_range in the year 2000 (they may not fit it now i.e be alot older but the only condition is that in the year 2000 they fit into that particular age_range).
The number_of_females column is the same as the number_of_males column except it is for females.
Can anyone assist me on how such a view could be written?
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert