title: SQL : count records per 5 minute intervals (including zeros)
body: <p>I have a responses table, which has a timestamp field (created_at), an id, and a foreign key (context_id)</p>
  
  <p>For a given context, I'd like to see how many responses occurred over 5 minute intervals.</p>
  
  <p>It is a very similar situation to the following question : </p>
  
  <p><a href="https://stackoverflow.com/questions/2125613/sql-server-count-records-including-zero-per-ten-minute-intervals">Sql Server: Count records (including zero) per ten-minute intervals</a></p>
  
  <p>Except that I am not using SQL Server, I'm using MySQL, but would like to see a more generic solution.</p>
  
  <p>There will be many 5 minute intervals in which there are 0 responses, which I'd like included in the results.</p>