How to see how many values are counted in group at certain day of life in sql?

user_17288230 0
Viewed 55

I have a dataframe:

day            id        value
1               a1       right 
2               a1       right 
2               a1       right 
2               a1       right  
3               a1       right 
4               a1       right 
1               b2       right 
1               b2       right 
2               b2       right 
3               b2       right

I want to count how many rows there were counted in sum at day 3 for each id group. So desired result is:

day            id       count
3               a1       5 
3               b2       4

How to do that? I know that in my query I have to write GROUP BY id. But how to count rows in sum at certain day?

trino presto mysql sql
2 Answers

This might work

SELECT MAX(day) day, id, COUNT(*) counts
FROM dataframe
WHERE day <= 3
GROUP BY id
user_170161440 
select '3' as "Day",id, count(value)
from dataset
where day
group by 2
user_192490270
Related