Count number of occurrences for each unique value [duplicate]

August 29, 2023 by Tarik

Yes, you can use GROUP BY:

SELECT time,
       activities,
       COUNT(*)
FROM table
GROUP BY time, activities;