sql - Oracle Query not Working -

oracle query not working. please specify wrong in query?

(select hacker_id,challenge_id, max(score) soc   submissions   group hacker_id,challenge_id   having max(score)>0) t2; 

please read @oldprogrammer comments. anyway, think should work you

select hacker_id,challenge_id, max(score) soc     submissions    group hacker_id,challenge_id    having max(score)>0;