Решение к #Задача9:

SELECT c.name AS city_name,
c.timezone_id AS timezone_id_city,
t.timezone_id AS timezone_id_timezone,
t.time_offset
FROM city c,
timezone t
ORDER BY c.name, t.timezone_id

#задача