I have an example data as below.
I want to calculate user count per city and user count per country.
Here's what I want:
How can I implement it in BigQuery as simple as possible?
Thanks a million!
question from:https://stackoverflow.com/questions/65952566/sql-to-calculate-the-overall-total-and-sub-total-number-but-unique