-- Database schema
| sales_in_weather : date [ DATE ] , store_nbr [ INTEGER ] , item_nbr [ INTEGER ] , units [ INTEGER ] | weather : station_nbr [ INTEGER ] , date [ DATE ] , tmax [ INTEGER ] , tmin [ INTEGER ] , tavg [ INTEGER ] , depart [ INTEGER ] , dewpoint [ INTEGER ] , wetbulb [ INTEGER ] , heat [ INTEGER ] , cool [ INTEGER ] , sunrise [ TEXT ] , sunset [ TEXT ] , codesum [ TEXT ] , snowfall [ REAL ] , preciptotal [ REAL ] , stnpressure [ REAL ] , sealevel [ REAL ] , resultspeed [ REAL ] , resultdir [ INTEGER ] , avgspeed [ REAL ] | relation : store_nbr [ INTEGER ] primary_key relation.store_nbr = sales_in_weather.store_nbr , station_nbr [ INTEGER ] relation.station_nbr = weather.station_nbr |
-- -- Which items from store 1 have the highest units sold during rainy day?

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;