title: ORA-00907: Missing right parenthesis
body: <pre><code>SELECT * FROM (
  SELECT SUM(A.Precio)AS "Total gastado", B.email FROM ARTICULO_EVENTO A
      JOIN (C.email FROM PEDIDO_ARTICULO_EVENTO C)B
      ON(B.email=A.email)
  WHERE B.FechaHora &gt; TO_DATE('20-08-2012', 'MM-DD-YYYY')
  GROUP BY (B.email)
  ORDER BY SUM(A.Precio) DESC
  )
  WHERE ROWNUM &lt;=5;
  </code></pre>
  
  <p>ORA-00907: Missing right parenthesis. At line 3.</p>
  
  <p>¿Why do i get this error?</p>