title: SQL: How to sum up count for many decades?
body: <p>I am learning SQL queries and have a question as below </p>
  
  <p>"A decade is a sequence of ten consecutive years, e.g. 1982, 1983... 1991. For each decade, compute the total number of publications in DBLP in that decade."</p>
  
  <p>I have come up with a temporary table for the count of each year with <code>select count(id) as cnt, year from publication group by year</code></p>
  
  <p>So the next step is to sum up the cnt for year decade. After some research, I found that I could use the <strong><em>BETWEEN</em></strong> operator. However, I still need to specify the range one by one. Is there any better way to do this? (The year range is 1900 - 2015)</p>
  
  <p>Thank you very much.</p>