title: ORA-00979 not a group by expression
body: <p>I am getting ORA-00979 with the following query:</p>
  
  <pre><code>SELECT cr.review_sk, cr.cs_sk, cr.full_name,
  tolist(to_char(cf.fact_date, 'mm/dd/yyyy')) "appt",
  cs.cs_id, cr.tracking_number
  from review cr, cs, fact cf
  where cr.cs_sk = cs.cs_sk
  and UPPER(cs.cs_id) like '%' || UPPER(i_cs_id) || '%'
  and row_delete_date_time is null
  and cr.review_sk = cf.review_wk (+)
  and cr.fact_type_code (+) = 183050
  GROUP BY cr.review_sk, cr.cs_sk, cf.fact_date, cr.tracking_number
  ORDER BY cs.cs_id, cr.full_name;
  </code></pre>
  
  <p>I couldn't find any examples that had both GROUP BY and ORDER BY clauses in the same query.  I tried removing each field from the group by one at a time, but am still getting the same error.</p>