BigQuery: Divided by sum of values in column to find the ratio

Question

I have a simple table with two columns Bin_name (int) and Count_in_this_bin (int)

I want to convert it to the ratio of each bin to the total count in all bins.

I used the following query in Google BigQuery:

SELECT count_in_bin/(SELECT SUM(count_in_bin) FROM [table])
FROM [table]

Then I get

error:Query Failed Error: Subselect not allowed in SELECT clause

Can anyone let me now the correct way to do this kind of simple divide in BigQuery?

Answer 1

BigQuery Legacy SQL

#legacySQL
SELECT 
  count_in_bin, 
  RATIO_TO_REPORT(count_in_bin) OVER() AS ratio
FROM [project:dataset.table]

BigQuery Standard SQL

#standardSQL
SELECT 
  count_in_bin, 
  count_in_bin / total AS ratio
FROM `project.dataset.table`, 
(SELECT SUM(count_in_bin) total FROM `project.dataset.table`)