Hi, i need to know how to create a code in both PIG and Hive for this data:

I need to obtain the sum of the newcases for the continents, as well as which country has had the highest number of cases in each continent and their number. somethig like:

For pig i was trying somethig like:

Any one knows how to do it?
Thanks.