query_cost_by_query_by_month.sql

SELECT
   date_trunc(date(creation_time),MONTH) as billing_month,
   user_email,
  query,
  count(distinct job_id) as query_runs,
  sum(total_bytes_billed) as total_bytes_billed,
  SUM(total_bytes_billed)/1e12*5 costInDollars
FROM
  `region-eu`.INFORMATION_SCHEMA.JOBS_BY_PROJECT
WHERE
  date_trunc(date(creation_time),MONTH) = '2021-05-01'
  AND job_type = "QUERY"
GROUP BY
  1,2,3
ORDER BY
  6 DESC
LIMIT 40