sumif complex

[lebowski]

hi everyone,

I have different cities and their population from different states.

I want to calculate the % of population of these cities over the total population of each states they belong to...

I thought about doing two differents queries, one to get the population of each state and another one to calculate the % but it dont work..

anybody with an idea ?

thx

 

[jshepar7]

Get those two queries together and then a third to make the calculation

 

[Brianwarnock]

hi everyone,

I have different cities and their population from different states.

I want to calculate the % of population of these cities over the total population of each states they belong to...

I thought about doing two differents queries, one to get the population of each state and another one to calculate the % but it dont work..

anybody with an idea ?

thx

Why, what happens, what is the SQL

It don't work don't actually help.

Brian