Which region has the highest medal number?
region refers to region_name; the highest medal number refers to MAX(COUNT(medal_id <> 4));
SELECT T5.region_name FROM medal AS T1 INNER JOIN competitor_event AS T2 ON T1.id = T2.medal_id INNER JOIN games_competitor AS T3 ON T2.competitor_id = T3.id INNER JOIN person_region AS T4 ON T3.person_id = T4.person_id INNER JOIN noc_region AS T5 ON T4.region_id = T5.id WHERE T1.id != 4 GROUP BY T5.region_name ORDER BY COUNT(T2.competitor_id) DESC LIMIT 1
database name:db_id olympics
city table city Cols: id dtype integer, city name dtype text, 
games table games Cols: id dtype integer, games year dtype integer, games name dtype text, season dtype text, 
games_city table games_city Cols: games id dtype integer, city id dtype integer, 
medal table medal Cols: id dtype integer, medal name dtype text, 
noc_region table noc_region Cols: id dtype integer, noc dtype text, region name dtype text, 
person table person Cols: id dtype integer, full name dtype text, gender dtype text, height dtype integer, weight dtype integer, 
games_competitor table games_competitor Cols: id dtype integer, games id dtype integer, person id dtype integer, age dtype integer, 
person_region table person_region Cols: person_id dtype integer, region_id dtype integer, 
sport table sport Cols: id dtype integer, sport name dtype text, 
event table event Cols: id dtype integer, sport id dtype integer, event name dtype text, 
competitor_event table competitor_event Cols: event id dtype integer, competitor id dtype integer, medal id dtype integer, 
