-- 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 ...

limit 2, 1; # After 2 we have also return 1 which will not print anything which is right after the record 2 # Aliasing - used to give temporary name to any column we want .