title: Multiple COUNT in 1 SQLITE Query
body: <p>Using SQLite.</p>
  
  <pre><code>   SELECT c.*,
            COUNT(m.course_id) AS "meeting_count",
            COUNT(r.meeting_id) AS "race_count"
       FROM course c
  LEFT JOIN meeting m ON m.course_id = c.id
  LEFT JOIN race r ON r.meeting_id = m.id
   GROUP BY c.id
  </code></pre>
  
  <p>Course has meetings has races.</p>
  
  <p>Trying to select the correct count for course meetings and course races. The problem is the above query is returning the same count for "meeting_count" as "race_count". What am I doing wrong?</p>