CODE EXAMPLE FOR SQL

mysql group by derived column

/* you can group by using the alias name*/
SELECT width*height as area FROM images GROUP BY area;