79581781

Date: 2025-04-18 21:56:54
Score: 0.5
Natty:
Report link

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.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: marky