How can we rename the COUNT(*) column in this query's result table?
COUNT(*)
AS
*
By using AS and an alias.