google bigquery - Referencing other columns in a SQL SELECT

Question

I have a SQL query in BigQuery:

SELECT
  creator.country,
  (SUM(length) / 60) AS total_minutes,
  COUNT(DISTINCT creator.id) AS total_users,
  (SUM(length) / 60 / COUNT(DISTINCT creator.id)) AS minutes_per_user
FROM
  ...

You may have noticed that the last column is equivalent to total_minutes / total_users.

I tried this, but it doesn't work:

SELECT
  creator.country,
  (SUM(length) / 60) AS total_minutes,
  COUNT(DISTINCT creator.id) AS total_users,
  (total_minutes / total_users) AS minutes_per_user
FROM
  ...

Is there any way to make this simpler?

Answer 1

Waitting for answers