title: oracle 10g sql with clause compilation error
body: <p>The compilation error says "mm" and "cc" is invalid identifier!</p>
  
  <pre><code>with m as (
    select instructor, 
           count(*) as c 
      from class 
  group by instructor),
       mm as ( 
    select max(m.c) as cc 
      from m)
  select m.instructor 
    from m 
   where m.c = mm.cc;
  </code></pre>