mysql group by issues

Struggling with group by.

MYSQL grouping using multiple columns

How group by will work internally when group by using three or more columns in mysql. Also explain the use of temp table table created for the query by the mysql