Select multiple columns from table but Group By one column

Question

Hi Have a table where I m having data like below

Now I want to group my data based on only country like below

I has to sum the data based on country only and show remaining columns.

Answer 1

Try something like this:

select [Date], [Day], sum([Calls]) as Calls
from MyTable
group by [Date], [Day]
order by [Date]