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 okERROR: ORA-00923: FROM keyword not found where expected. How may I fix this. Thanks in Advance! still i got the error. specify the table. Instead of *, use brand.*, PRDUCT.*,