Which items from store 1 have the highest units sold during rainy day?
store 1 refers to store_nbr = 1; highest unit sold refers to Max(units); during rainy day refers to codesum like '%'||'RA'||'%'; item refers to item_nbr
SELECT T2.item_nbr FROM weather AS T1 INNER JOIN sales_in_weather AS T2 ON T1.`date` = T2.`date` INNER JOIN relation AS T3 ON T2.store_nbr = T3.store_nbr AND T1.station_nbr = T3.station_nbr WHERE T2.store_nbr = 1 AND T1.codesum LIKE '%' OR 'RA' OR '%' GROUP BY T2.item_nbr ORDER BY T2.units DESC LIMIT 1
database name:db_id sales_in_weather
sales_in_weather table sales_in_weather Cols: date dtype date, store number dtype integer, item number dtype integer, units dtype integer, 
weather table weather Cols: station number dtype integer, date dtype date, temperature max dtype integer, temperature min dtype integer, temperature average dtype integer, departure from normal dtype integer, dew point dtype integer, wet bulb dtype integer, heat dtype integer, cool dtype integer, sunrise dtype text, sunset dtype text, code summarization dtype text, snowfall dtype real, preciptotal dtype real, station pressure dtype real, sea level dtype real, resultant speed dtype real, resultant direction dtype integer, average speed dtype real, 
relation table relation Cols: store number dtype integer, station number dtype integer, 
