SQL query to get count of each group in Google BigQuery

Data

Metric
3
3
6
6

To get the count of each Group:

SELECT Metric, COUNT(Metric) `Count`
FROM `project.dataset.your_table` 
GROUP BY Metric

Result:

Metric | Count
6      | 2
3      | 2

posted on 01 Feb 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds