gistfile1.sql

select  'flag:' || lower(sc.code) || ':' || sc.name, 
		d.downloads, (d.downloads/t.total)*100 
from	(select country_code,sum(relative_value) as downloads from stats.download_country_month
		 where year=?
             	 group by country_code) as d,
		 stats.country sc,
		 (select sum(relative_value::real) as total from stats.download_month
		  where year=?) as t
         where d.country_code = sc.code
         order by d.downloads desc;