title: Sequel: How to use group and count
body: <p>Simply put, how can I do this query using <a href="http://sequel.rubyforge.org/" rel="noreferrer">Sequel</a>?</p>
  
  <pre><code>select a.id, count(t.id)
  from albums a
  right join tracks t on t.album_id = a.id
  group by a.id
  </code></pre>