i need to group by and sum to specific col

Question

hi guys

pls help me

 

i need to create query by group by and sum to specific columns and excute by where cluase like enter Country , please see the TBL

 

 

Thanks .