SQLPlayground

-- Welcome to SQLPlayground! This is a real SQLite database
-- running in your browser. Press Ctrl+Enter (Cmd+Enter on Mac) to run.
-- (LEFT JOIN keeps online events, which have no venue.)

SELECT e.name, e.category, v.city, e.start_date, e.ticket_price
FROM events e
LEFT JOIN venues v ON v.id = e.venue_id
ORDER BY e.start_date
LIMIT 10;