The way I see your query, it did not include all non-aggregated SELECT
columns in the GROUP BY
. This could make your query inconsistent.
Try updating your line 7 to:
GROUP BY usr.created\\\_date, usr.variant
You can check Query Execution Plan to have an insight and steps BigQuery has to take to run your query.