Your SQL query has been executed successfully.

SHOW CREATE TABLE players



players	CREATE TABLE `players` (
  `player_id` int(11) NOT...

CREATE TABLE `players` (
 `player_id` int(11) NOT NULL AUTO_INCREMENT,
 `display_name` varchar(32) NOT NULL,
 `auth_system` varchar(6) NOT NULL,
 `platform_id` varchar(32) NOT NULL,
 `user_level` int(11) NOT NULL,
 `rating` double NOT NULL,
 PRIMARY KEY (`player_id`),
 KEY `platform_auth` (`auth_system`(1),`platform_id`) USING BTREE,
 KEY `rating` (`rating`)
) ENGINE=InnoDB AUTO_INCREMENT=7132 DEFAULT CHARSET=latin1

SELECT cnt, COUNT(*) AS groups
FROM
( SELECT COUNT(*) AS cnt
  FROM players
  GROUP BY auth_system, platform_id
) AS x
GROUP BY cnt
ORDER BY cnt DESC ;

(`auth_system`(1),`platform_id`)

CREATE INDEX auth_system_platform_id__ix
ON players (auth_system, platform_id) ;

SQL Cleanup. Run time 736ms, total time 736ms: AuthenticationLookup{authSystem='guest', providerId='guest_v12684'}
SQL Cleanup. Run time 2201ms, total time 2201ms: AuthenticationLookup{authSystem='github', providerId='Zomis'}

SET profiling = 1;
SELECT ... -- your query ;
SHOW profiles;