Table: bab_lamrissa
Columns: name
geographic_code
type
households
population_2004
foreign_population
moroccan_population

Question: Which Foreign population has a Population (2004) larger than 234733?
SQL: SELECT AVG("foreign_population") FROM bab_lamrissa WHERE "population_2004" > 234733

Question: Which Population (2004) has a Moroccan population larger than 234506?
SQL: SELECT AVG("population_2004") FROM bab_lamrissa WHERE "moroccan_population" > 234506