title: Error while executing SQL query on database 'database': near "GROUP": syntax error
body: <p>I am starting to learn SQL so I need to make some exercises. One of the exercises I just can't find out how to do it.
  We've got a database with 4 tables. And in this exercise is like:
  Show an overview of the brands and type of scooters that are hired by people from Almelo, living in a random street with a house number 2. An extra condition is that the total amount paid should be more than 100 euros. Also show the total amount of the contract.</p>
  
  <p>I have tried much and almost got it. But now I get everytime this error (see title)</p>
  
  <p>This is my query:</p>
  
  <pre><code>SELECT merk, type, SUM(betaald_bedrag)
  FROM T_contract
  INNER JOIN T_klant ON T_contract.klantnummer = T_klant.klantnummer
  INNER JOIN T_betaling ON T_contract.contractnummer = T_betaling.contractnummer
  WHERE plaats = "Almelo"
  AND adres LIKE "% 2"
  HAVING SUM(betaald_bedrag) &gt; 100
  GROUP BY T_betaling.contractnummer
  </code></pre>
  
  <p>Can you please help me to solve this?</p>