title: Temporary table in FROM clause instead of WITH clause
body: <p>I have this query (which runs perfect):</p>
  
  <pre><code>WITH TEMPTABLE AS(
              SELECT count(CONTRACT_ID) AS no_contract, T.BRANCH_ID as branch
              FROM CONTRACT, "EMPLOYMENT" T, TABLE(T."EMPLOYEE") TT
              WHERE CONTRACT.EMPLOYEE_ID = TT.EMPLOYEE_ID
                    AND CONTRACT.CONTRACT_VT_START BETWEEN '01/01/2018' AND '30/06/2018'
              GROUP BY T.BRANCH_ID
          )
          SELECT branch
          FROM TEMPTABLE
          WHERE no_contract IN (SELECT MAX(no_contract)
                               FROM TEMPTABLE);
  </code></pre>
  
  <p>And I was wondering if it can be done with another way instead of WITH clause. Something like this:</p>
  
  <pre><code>SELECT count_per_branch.BRANCH
  FROM (SELECT count(CONTRACT_ID) AS no_contract, BRANCH_ID AS BRANCH
        FROM CONTRACT, "EMPLOYMENT" T, TABLE(T."EMPLOYEE") TT
        WHERE CONTRACT.EMPLOYEE_ID = TT.EMPLOYEE_ID
              AND CONTRACT.CONTRACT_VT_START BETWEEN '01/01/2018' AND '30/06/2018'
        GROUP BY T.BRANCH_ID) count_per_branch
  WHERE count_per_branch.no_contract =
              (SELECT max(count_per_branch.no_contract)
               FROM count_per_branch);
  </code></pre>
  
  <p>Which gives an ORA-00942: "table or view does not exist"
  Error at Line: 9</p>