title: expecting IDENT, found ''[Under 18]''
body: <p>I'm trying to execute this query, it's work in <code>phpMyAdmin</code> but not in my method it give me this Exception </p>
  
  <pre><code>expecting IDENT, found ''[Under 18]'': line 1:53: expecting IDENT, found ''[Under 18]''
  </code></pre>
  
  <p>this is my method  :</p>
  
  <pre><code>public List&lt;Object[]&gt; getTranche() {
      List&lt;Object[]&gt; list;
  
      Query req = em.createQuery("SELECT SUM(CASE WHEN age &lt; 18 THEN 1 ELSE 0 END) AS '[Under 18]', SUM(CASE WHEN age BETWEEN 18 AND 24 THEN 1 ELSE 0 END) AS '[18-24]', SUM(CASE WHEN age BETWEEN 25 AND 34 THEN 1 ELSE 0 END) AS '[25-34]' FROM Contrat ");
  
      return (List&lt;Object[]&gt;) req.getResultList();
  }
  </code></pre>
  
  <p>any help please </p>