Consider the following query:
SELECT country , count(id) AS "count" FROM lead WHERE date_part('year', lead.since) = date_part('year', CURRENT_DATE) GROUP BY "country" ORDER BY "count" DESC ;
It returns something like:
country count fr 3456 us 569 sc 248 …
How can I add a third column with the percentage of the total count?