PyGotham room schedule

schedule.sql

SELECT
    TO_CHAR(s.start, 'HH12:MIAM') AS start,
    TO_CHAR(s.end, 'HH12:MIAM') AS end,
    u.name,
    t.name
FROM
    rooms r
JOIN rooms_slots rs ON r.id = rs.room_id
JOIN slots s ON rs.slot_id = s.id
JOIN presentations p ON s.id = p.slot_id
JOIN talks t ON p.talk_id = t.id
JOIN users u ON t.user_id = u.id
JOIN days d ON s.day_id = d.id
WHERE d.id = 1
  AND r.id = 1
ORDER BY
    r.order,
    s.start;