ERROR: ORA-00923: FROM keyword not found where expected

ora 923SQL 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 okI 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 another