instruction: For those dates with a max temperature greater than or equal to 80, I would like a line chart to show the tendency, display by the X in asc.
response: SELECT date, COUNT(date) FROM weather WHERE max_temperature_f >= 80 GROUP BY date ORDER BY date