What is the maximum and minimum temperature for station number 1 on 15 January 2012?
station number 1 refers to station_nbr = 1 ; minimum temperature = tmin; maximum temperature = tmax; on 15 January 2012 refers to date = '2012-01-15'
SELECT tmax, tmin FROM weather WHERE station_nbr = 1 AND `date` = '2012-01-15'