b_UNION.sql

-- Use union to combine the results from two or more select statements (only distinct values)
SELECT county, station, max(temp) as max_temp, min(temp) as min_temp
FROM hrly_Irish_weather
WHERE county = "Cork"
GROUP BY county, station
UNION
SELECT county, station, max(temp) as max_temp, min(temp) as min_temp
FROM hrly_Irish_weather
WHERE county = "Galway" 
GROUP BY county, station;