INSERT INTO venues(name, postal_code, country_code) VALUES ('My Place', '97205', 'us'); INSERT INTO events (title, starts, ends, venue_id) VALUES ('Moby', '2012-02-06 21:00:00', '2012-02-06 23:00:00', ( SELECT venue_id FROM venues WHERE name = 'Crystal Ballroom' ) ); INSERT INTO events (title, starts, ends, venue_id) VALUES ('Wedding', '2012-02-26 21:00:00', '2012-02-26 23:00:00', 2), ('Dinner wit