GROUP BY clause and Distinct Query

Can someone tell me where the GROUP BY clause gets added to in the mysql query.

I am never sure with this one where it goes: whether it is before or after an order by clause?

Also,

what is the DISTINCT query, is this the same or something different?

Hi there!

The grouping can be quite tricky, particularly as the queries get more and more complicated.

Basically it should go before the order by clause. The distinct query returns unique values rather than grouping values.