HELP CORRECT THIS . KEEP GETTING ERROR STATING Error at Command Line : 143 Column : 1 Error report - SQL Error: ORA-00933: SQL command not properly...

HELP CORRECT THIS .

KEEP GETTING ERROR STATING

Error at Command Line : 143 Column : 1

Error report -

SQL Error: ORA-00933: SQL command not properly ended

00933. 00000 - "SQL command not properly ended"

SELECT E_NUMBER,E_Fname, E_Lname, QUANTITY,(SUM)PRICE

FROM EMPLOYEES

WHERE E_NUMBER IN ( SELECT E_NUMBER

FROM ORDERS)

WHERE QUANTITY IN (SELECT QUANTITY 

FROM ORDERS)

WHERE PRICE IN (SELECT PRICE

FROM ITEM);