$6.$ Create a query to calculate the average age and count for all groupings of GENDER and RACE. For theCreate a query to calculate the average age and count for all groupings of GENDER and RACE. For the case where the a null entry means null, replace that with 'all'. Put the result in order of GENDER, RACE.

The beginning of your result should look like the following.

$\backslash$table$[[$GENDER$,$RACE,AVERAGE$\_$AGE,COUNT$],[$all$,$all,$26,13812],[$all$,$white,$9,1],[$all$,$Black,$28,1907],[$all$,$Indian,$24,3],[$all$,$Mulatto,$27,450],[$all$,$White,$26,11450],[$all$,-,19,1],[$Female$,$all,$26,6523],[$Female$,$white,$9,1],[$Female$,$Black,$28,928]]$

case where the a null entry means null, replace that with 'all'. Put the result in order of GENDER, RACE.

The beginning of your result should look like the following.