title: How to write this subselect sql into jpql?
body: <p>How do I transform the below sql into jpql? I'm just trying to count the number of rows returned by sub select.</p>
  
  <pre><code>select count(*) from (select t.prop1 from table1 t where t.someprop ='123' group by t.num);
  </code></pre>
  
  <p>I've tried</p>
  
  <pre><code>@Query("Select count(*) from (select t.prop1 from table1 t where t.someprop ='123' group by t.num")
  </code></pre>