mysql - SQL view syntax -

so have table want create view with, not entirely sure how go it..

so lets have table with:

• index
• country
• city
• population

and want make view showing each country , sum of it's population, sounds easy, having trouble wrapping head around select used create view.

just standard mysql if makes difference. thanks!

for mysql like:

select country, sum(population) total_population table  group country