Find the count of all names.
The column header of the result is count(name).
We can use AS to change the column header name to something more meaningful like count_of_names. AS stands for ALIAS.
Now the column header name has been changed to count_of_names.