title: ORA-00928: missing SELECT keyword when using with clause
body: <p>My SQL query is: </p>
  
  <pre><code>with temp1 (hacker_id, chlng_cnt) as 
  (
       select hacker_id, count(challenge_id) as chlng_cnt 
       from Challenges 
       group by hacker_id
  );
  </code></pre>
  
  <p>where the table <code>Challenges</code> has this schema:</p>
  
  <pre><code>Challenges(hacker_id, challenge_id)
  </code></pre>
  
  <p>I don't see any mistake with my query, I have used the <code>select</code> keyword. So why am I getting this error?</p>