Maybe all they really want to do is say:

SELECT FIELD1, FIELD2 FROM MYTABLE ORDER BY FIELD1, FIELD2

Do you think that's what they meant?
i think so.. i just want to hear about using group by and distinct methods in detailed from the master... 10nx