How to Calculate Percentage Between Two Numbers Using SQL on Bigquery

How to calculate percentage between two numbers using SQL on BigQuery?

BigQuery Calculating Percent Overlap Between Values Multiple Columns

How to compute percentages in BigQuery SQL for SUM?

BigQuery - How to calculate percentage change row by row?

calculate percentage from BigQuery table Standard SQL

calculating percentage of two columns in SQL - using BigQuery

SELECT
  primary_type,
  clearance_status,
  COUNT(*) AS clearance_status_count,
  (SUM(COUNT(*)) OVER(PARTITION BY primary_type)) AS total,
  COUNT(*) / (SUM(COUNT(*)) OVER(PARTITION BY primary_type)) AS ratio
FROM
  `bigquery-public-data.austin_crime.crime`
GROUP BY
  primary_type,
  clearance_status
ORDER BY
  primary_type,
  clearance_status;

This query works across the different primary_types. I included the count and the total to show that the ratio is correct.

Similar question here: Calculate percentage of group using GROUP BY

How to use sql query to find percentage on the basis of certain conditions?

percentage per month Bigquery

BigQuery SQL: percent with 2 decimal places

---

Related Topics