gistfile1.txt

#standardsql

WITH agg1 AS(
  SELECT device_category, result_position, COUNT(*) as num_contacts
  FROM sandbox.ir_ranking_contacts_td_apr17_18
  WHERE quote_pk IS NOT NULL AND quote_pk > 0
  GROUP BY 1,2
),

agg2 AS (
SELECT device_category, result_position, num_contacts*100/total_contacts as perc_total_contacts
FROM agg1 a, (SELECT COUNT(*) as total_contacts FROM sandbox.ir_ranking_contacts_td_apr17_18 WHERE quote_pk IS NOT NULL AND quote_pk > 0) b
)

SELECT * FROM agg2 ORDER BY 3 DESC