CREATE TABLE record (ID INT, Result TEXT, Swimmer_ID INT, Event_ID INT)
CREATE TABLE stadium (ID INT, name TEXT, Capacity INT, City TEXT, Country TEXT, Opening_year INT)
CREATE TABLE swimmer (ID INT, name TEXT, Nationality TEXT, meter_100 FLOAT, meter_200 TEXT, meter_300 TEXT, meter_400 TEXT, meter_500 TEXT, meter_600 TEXT, meter_700 TEXT, Time TEXT)
CREATE TABLE event (ID INT, Name TEXT, Stadium_ID INT, Year TEXT)

Find the names of swimmers who has a result of 'win', and count them by a bar chart
SELECT name, COUNT(name) FROM swimmer AS t1 JOIN record AS t2 ON t1.ID = t2.Swimmer_ID WHERE Result = 'Win' GROUP BY name
SELECT "name", COUNT("name") FROM "swimmer" AS "t1" JOIN "record" AS "t2" ON "t1"."ID" = "t2"."Swimmer_ID" WHERE "Result" = 'Win' GROUP BY "name"