How can we rename the result column when using COUNT?
COUNT
AS
COUNT()
By aliasing it with AS and a new name.