Sign-Up Flow Optimization Analysis with SQL and Tableau

Question

The provided query for this exercise does not work. It keeps returning the only_full_group_by error. Perhaps, you could also give hint on the total number of expected rows from the output of the query. I'm currently stuck on this query.

Answer 1

Hi Oluwaseyi!
Thanks for reaching out!
The issue you're facing with only_full_group_by in the login query is due to using non-aggregated columns in the SELECT clause that aren't included in the GROUP BY clause.

Not everyone receives this error because it depends on how their MySQL server is configured. If the ONLY_FULL_GROUP_BY mode is enabled (which is the default in newer MySQL versions), queries that don’t follow the above-mentioned rule will throw an error.
To avoid the error, we modified the signup queries by using functions like ANY_VALUE() for non-grouped fields. Here, you can use a similar approach.

We'll attach a .sql file with a modified version of the query, so it avoids the error. That said, feel free to approach the task in your own way, as it’s intended to be a homework-style assignment. Thank you!

Best,
Ivan

Sign-Up Flow Optimization Analysis with SQL and Tableau

Submit an answer

related questions