How many swimming records are there in the system?
select count(*) from record
What about that in terms of swimmer ids?
select swimmer_id, count(*) from record group by swimmer_id
Show me the one with the most of them.
select swimmer_id from record group by swimmer_id order by count(*) desc limit 1
Give me that swimmer's name.
select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id group by t2.swimmer_id order by count(*) desc limit 1