该过程称为枢转。一种方法是:
select Country
, sum(case when Month = 'June' then Number end) as June
, sum(case when Month = 'May' then Number end) as May
, sum(case when Month = 'April' then Number end) as April
from YourTable
group by
Country