person ate most, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

drop table if exists mytable\\

create table mytable (person varchar(100), ate varchar(100))\\

insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Chicken')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Joe','Tuna')\\
insert into mytable(person, ate) values ('Rob','Chicken')\\
insert into mytable(person, ate) values ('Rob','Tuna')\\
insert into mytable(person, ate) values ('Rob','Chicken')\\
insert into mytable(person, ate) values ('Rob','Chicken')\\
insert into mytable(person, ate) values ('Rob','Chicken')\\
insert into mytable(person, ate) values ('Rob','Chicken')\\
insert into mytable(person, ate) values ('Jonathan','Tuna')\\
insert into mytable(person, ate) values ('Jonathan','Tuna')\\
insert into mytable(person, ate) values ('Jonathan','Chicken')\\
insert into mytable(person, ate) values ('Jonathan','Tuna')\\
insert into mytable(person, ate) values ('Jonathan','Chicken')\\

select person, substr(max(combined), 15) as ate_most
from
(
  select person, concat(lpad(count(*), 14, '0'), ate) as combined
  from mytable
  group by person, ate
) trick
group by person
order by person\\

drop table mytable\\


absolute service time: 0,43 sec