How to fix ORA-00923: FROM keyword not found where

ora 923ORA-00923 occurs when you try to execute a SELECT or REVOKE statement without a FROM keyword in its correct form and place. If you are seeing this error, the keyword FROM isORA-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)