What was the most highest number bronze medal when it was total 4 medal, 1 silver medal, and less than 2 medal?
Rank Nation Gold Silver Bronze Total
Boxing at the 1990 Asian Games
18700993
text text real real real real
2-18700993-1
Medal table
Medal table
1 South Korea (KOR) 5 2 2 9
2 Thailand (THA) 2 1 1 4
3 China (CHN) 1 5 1 7
4 Pakistan (PAK) 1 1 4 6
5 Philippines (PHI) 1 0 3 4
6 Indonesia (INA) 1 0 2 3
7 Syria (SYR) 1 0 0 1
8 Mongolia (MGL) 0 1 4 5
9 Iran (IRI) 0 1 2 3
10 Japan (JPN) 0 1 1 2
11 India (IND) 0 0 1 1
11 Laos (LAO) 0 0 1 1
11 Nepal (NEP) 0 0 1 1
Total Total 12 12 23 47
SELECT MAX Bronze FROM table WHERE Total = 4 AND Silver = 1 AND Gold < 2
4 1 2