Error (ORA-00923: FROM keyword not found where expected)

ora 923I have been getting the error ORA-00923: FROM keyword not found where expected and do not know why, please help. Do check for missing spaces in the sql query. I ran into anotherSQL Error: ORA-00923: FROM keyword not found where expected. Can anyone tell me where I'm going wrong with this? you don't need the WITHIN GROUP clause. it's ok