[FR] COUNT(DISTINCT col1) ... GROUP BY

[Minyus]

Thank you for the great tool!

I'd like to request feature which works like COUNT(DISTINCT col1) ... GROUP BY of SQL. I tried count_agg(distinct col1), but got syntax error.

[dcmoura]

Hi, thank you :-)

The syntax is a little different in SPyQL. Please try:

SELECT count_distinct_agg(col1) ...

You can check the reference for more aggregation functions: https://spyql.readthedocs.io/en/latest/reference.html#module-spyql.agg

Please let me know if you were able to do what you needed. Thanks!

[Minyus]

Ok, I'll try. Thank you!

[Minyus]

Worked like a charm! Thank you!