select countryname as Country ,count(countrystat.call) as Worked,count(countrystat.rcvd) as Confirmed from countrystat,countrylist where countrystat.mainprefix = countrylist.mainprefix group by countrystat.mainprefix order by countryname