When was the hottest temperature recorded? If there are multiple dates with the hottest temperature, indicate all of the dates.
the hottest temperature refers to max_temperature_f;
SELECT max_temperature_f, date FROM weather WHERE max_temperature_f = ( SELECT MAX(max_temperature_f) FROM weather WHERE max_temperature_f IS NOT NULL AND max_temperature_f IS NOT '' )