SAMPLE QUERY :
SELECT name, SUM(population)
where population >1000
query failed and got error msg 8120
"Column 'tt.dbo.bbc.name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
I want to select name and corresponding sum (population) ..