c_ORDER_BY.sql

-- Order the results by column ascending
SELECT county, station, max(temp) as max_temp, min(temp) as min_temp
FROM hrly_Irish_weather
WHERE county = "Cork"
GROUP BY county, station
ORDER BY max_temp;
-- Order the results by column descending
SELECT county, station, max(temp) as max_temp, min(temp) as min_temp
FROM hrly_Irish_weather
WHERE county = "Cork"
GROUP BY county, station
ORDER BY max_temp DESC;