FROM tbl
GROUP BY date
は論外だし、
WITH days AS (
SELECT COUNTIF(A) AS numA, COUNT(*) AS total
FROM tbl
GROUP by date
)
SELECT total >= 100 AND ratio > 0.5 AS succeeded
FROM days
もboilerplateが多すぎて読みにくいし。条件が複雑になればなるほど効いてくる。
FROM tbl
GROUP BY date
は論外だし、
WITH days AS (
SELECT COUNTIF(A) AS numA, COUNT(*) AS total
FROM tbl
GROUP by date
)
SELECT total >= 100 AND ratio > 0.5 AS succeeded
FROM days
もboilerplateが多すぎて読みにくいし。条件が複雑になればなるほど効いてくる。