Which cities have hosted events?
select city from city as t1 join hosting_city as t2 on t1.city_id = t2.host_city
What is the average temperature in March of these cities?
select avg(mar) from city as t1 join hosting_city as t2 on t1.city_id = t2.host_city join temperature as t3 on t3.city_id = t2.host_city
Among these cities, whose temperature in Mar is lower than that in July?
select t1.city from city as t1 join temperature as t2 on t1.city_id = t2.city_id where t2.mar < t2.jul intersect select t3.city from city as t3 join hosting_city as t4 on t3.city_id = t4.host_city