4-role-counter.sql

-- Given a table GAMERS, query for the count of each Role of the Players in the given table. Sort the result based on ascending order of the count and print the result in the following format:

-- [Role] Count is [Role_Count]


SELECT   CONCAT(Role, ' Count is ', COUNT(Role)) as COUNT
FROM     GAMERS
GROUP BY Role
ORDER BY COUNT(Role)