title: Count occurrences of a column value efficiently in SQL?
body: <p>I have a Car table</p>
  <pre><code>id   | make   | model
  --------
  1000 | Toyota | Cammry
  1001 | Toyota | Harrier
  1002 | Honda  | Accord
  1003 | Honda  | Civic
  </code></pre>
  <p>I have a Driver table</p>
  <pre><code>id   | name| car
  --------
  2000    Finch   1000
  2001    Shin    1001
  2002    Edward  1003
  2003    Qing    1001
  2004    Prasad  1002
  </code></pre>
  <p>I need write a single SQL query to find out how many drivers are there for each vehicle? (result must have both vehicle make &amp; model and number of drivers)</p>