# LIMIT can be combined with ORDER BY to make it more powerful. E.g. If we want to know thw three oldest employees, we say... -- What this means is that we're starting at position 3, which was Leslie, ...
-- aliasing is the way to change the name of the column select gender, avg (age) as ave_age # this will return average age as ave_age as an alias but not changing it completely ...