COUNT/MAX(COUNT)在BigQuery中不起作用

Question

我不太习惯SQL，但我自己已经能够运行以下代码：

SELECT
event_name,
COUNT(event_name) AS count,
COUNT(event_name) / SUM(COUNT(event_name)) OVER () * 100 AS event_percent
FROM `table_1`
WHERE
event_name IN ('session_start', 'view_item', 'select_item', 'add_to_cart', 'remove_from_cart', 'begin_checkout', 'purchase' )
GROUP BY
event_name
ORDER BY
count DESC

在此处输入图像描述

我想得到的是每个计数的百分比除以最大计数。示例：购买/会话_启动(22/1258(

如果有人能帮忙的话。。我试过一些东西，但都不起作用

Answer 1

我想CTE可以

WITH prep AS (
SELECT
event_name,
COUNT(event_name) AS cnt,
COUNT(event_name) / SUM(COUNT(event_name)) OVER () * 100 AS event_percent
FROM `table_1`
WHERE
event_name IN ('session_start', 'view_item', 'select_item', 'add_to_cart', 'remove_from_cart', 'begin_checkout', 'purchase' )
GROUP BY
event_name
ORDER BY
count DESC
)
SELECT
*,
cnt / max(cnt) over()  
FROM
prep