Case when usage

country population (Population) China 600 USA 100 Canada 100 UK 200 France 300 Japan 250 Germany 200 Mexico 50 India 250 according to population data of this country, count the population of Asia and North America. Select sum (Population ), case country when 'China' then' Asia 'when' India 'then' Asia 'when' Japan 'then' Asia 'when' USA 'then' North America 'when' Canada 'then' north America 'when' Mexico 'then' North America 'else' miscellaneous 'end from table_a group by case country when' China 'then' Asia 'when' India 'then' Asia 'when' Japan 'then' Asia 'when' USA 'then' North America 'when' Canada 'then' North America 'when' Mexico 'then' North America 'else' other 'ends;

Case when usage