title: SQL, Count statement
body: <pre><code>select count(characterid) as num , schoolhouseid
  from student natural join Character
  </code></pre>
  <p>Pretty much a beginner in SQL, trying to figure out why the count statement crashes the syntax.
  it works without schoolhouseid and also without the count but together it crashes</p>