Can you list the names of all the swimmers who have won more than once?
SELECT t1.name  FROM swimmer AS t1 JOIN record AS t2 ON t1.id   =   t2.swimmer_id WHERE RESULT   =   'Win' GROUP BY t2.swimmer_id HAVING count ( * )   >  1
swimmers who have won more than once refers to HAVING COUNT(*) > 1; names of all the swimmers refers to SELECT t1.name;