to show date, time, and temperature recorded in Chicago:

mysql> select d,t,temp from inputdata where p = 'Chicago'

to show all records, sorted by temperature in descending order:

mysql> select * from inputdata order by temp desc