ORA

ora 923 ORA-00923: FROM keyword not found where expected Below is the SQL : SELECT A.Agent_key, Sum(Total_Orders) FROM (SELECT A.Agent_key, Sum(Total_Orders). What causes an ORA-00923 error? In a SELECT or REVOKE statement, the keyword FROM was either missing, misplaced, or misspelled. The keyword FROM must follow

ora 923, The ORA-00923: FROM keyword not found where expected error occurs when the FROM keyword is missing, misspelled, or misplaced in the Oracle SQL statement such as select or.