Basically I have a table similar to this:

time.....activities.....length  
13:00........3.............1  
13:15........2.............2  
13:00........3.............2  
13:30........1.............1  
13:45........2.............3  
13:15........5.............1  
13:45........1.............3  
13:15........3.............1  
13:45........3.............2  
13:45........1.............1  
13:15........3.............3

A couple of notes:

  • Activities can be between 1 and 5
  • Length can be between 1 and 3

The query should return:

time........count  
13:00.........2  
13:15.........2  
13:30.........0  
13:45.........1

Basically for each unique time I want a count of the number of rows where the activities value is 3.

So then I can say: 

At 13:00 there were X amount of activity 3s.
At 13:45 there were Y amount of activity 3s.

Then I want a count for activity 1s,2s,4s and 5s. so I can plot the distribution for each unique time.

sql count
Edit
Report