ประเทศใดอยู่ก่อนฝรั่งเศส ไม่จำเป็นต้องใช้ตารางทั้งหมด
what country is listed before france ?It is not neccessary to use all the tables.
 table_203_374:  id [ number]  "rank" [ number]  "nation" [ text]  "gold" [ number]  "silver" [ number]  "bronze" [ number]  "total" [ number] 
SELECT "nation" FROM table_203_374 WHERE id = (SELECT id FROM table_203_374 WHERE "nation" = 'france') - 1