What is the difference between the units sold for item 1 when the sunset was the earliest and the latest?
item 1 refers to item_nbr = 1; when the sunset earliest refers to Min(sunset); latest sunset refers to Max(sunset); difference unit sold refers to Subtract(Sum(units where Min(sunset)), Sum(units where Max(sunset)))
SELECT ( SELECT SUM(T2.units) AS sumunit 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 WHERE T2.item_nbr = 5 AND sunset IS NOT NULL GROUP BY T1.sunset ORDER BY T1.sunset LIMIT 1 ) - ( SELECT SUM(T2.units) AS sumunit 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 WHERE T2.item_nbr = 5 AND sunset IS NOT NULL GROUP BY T1.sunset ORDER BY T1.sunset 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, 
