ora 923The error message ORA-00923 points to a problem in the SQL statement structure, specifically indicating that the FROM keyword is not where Oracle expects it to be. ThisSQL 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