userid MIN(t1.score) 1 1 2 2 3 3 userid MIN(t1.score) 1 1 2 2 userid MIN(t1.score+0.0) 1 1.0 2 2.0 cid CONCAT(firstname, ' ', surname) COUNT(call_id) cid CONCAT(firstname, ' ', surname) COUNT(call_id) value description bug_id BBBBBBBBBBBBB - conversion 9 BBBBBBBBBBBBB - conversion 10 BBBBBBBBBBBBB - generic 7 BBBBBBBBBBBBB - generic 14 BBBBBBBBBBBBB - eeeeeeeee NULL kkkkkkkkkkk lllllllllll 6 kkkkkkkkkkk lllllllllll 8 kkkkkkkkkkk lllllllllll 12 Test Procedures NULL Documentation NULL Host communication NULL value description COUNT(bug_id) BBBBBBBBBBBBB - conversion 2 BBBBBBBBBBBBB - eeeeeeeee 0 BBBBBBBBBBBBB - generic 2 Documentation 0 Host communication 0 kkkkkkkkkkk lllllllllll 3 Test Procedures 0 1+1 a count(*) 2 a 0 1+1 a count(*) 2 a 0 table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 6 Using temporary userid count(*) 3 3 2 1 1 2 table type possible_keys key key_len ref rows Extra t1 range spID spID 5 NULL 2 where used; Using index; Using temporary table type possible_keys key key_len ref rows Extra t1 range spID spID 5 NULL 2 where used; Using index spid count(*) 1 1 2 2 spid count(*) 2 2 1 1 table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 6 Using filesort spid sum(userid) 5 3 4 3 3 3 2 3 1 1 table type possible_keys key key_len ref rows Extra t1 index NULL score 3 NULL 6 Using index score count(*) 3 3 2 1 1 2 One Two sum(Four) 1 1 16 1 2 16 1 3 16