if you know what is GROUP BY and still don't understand why oracle return such error and still don't want to go tahiti.oracle.com..
well, i suggest you go for Introduction to SQL-PL/SQL course.

Hope you will understand...else better don't deal with oracle DB anymore