
INSERT INTO ascent
    (mountain_id, climber_id, date_of_ascent, notes)
VALUES
    ((SELECT id FROM mountain WHERE name = 'Washington' AND state = 'NH'),
     (SELECT id FROM climber  WHERE first_name = 'Alice' AND last_name ='Atlas'),
     '2022-01-01',
     'Bob froze. Poor Bob.'),
    ((SELECT id FROM mountain WHERE name = 'Washington' AND state = 'NH'),
     (SELECT id FROM climber  WHERE first_name = 'Bob' AND last_name = 'Bobblehead'),
     '2022-01-01',
     'I froze.'),
    ((SELECT id FROM mountain WHERE name = 'Mansfield' AND state = 'VT'),
     (SELECT id FROM climber  WHERE first_name = 'Alice' AND last_name = 'Atlas'),
     '2021-08-15',
     NULL),
    ((SELECT id FROM mountain WHERE name = 'Lafayette' AND state = 'NH'),
     (SELECT id FROM climber  WHERE first_name = 'Alice' AND last_name = 'Atlas'),
     '2021-07-10',
     NULL),
    ((SELECT id FROM mountain WHERE name = 'Killington' AND state = 'VT'),
     (SELECT id FROM climber  WHERE first_name = 'Carol' AND last_name = 'Carolina'),
     '2021-08-10',
     'http://www.supersecret.org/~ccarolina/hikes/killington.html'),
    ((SELECT id FROM mountain WHERE name = 'Killington' AND state = 'VT'),
     (SELECT id FROM climber  WHERE first_name = 'David' AND last_name = 'Divinator'),
     '2021-07-04',
     NULL),
    ((SELECT id FROM mountain WHERE name = 'Camel''s Hump' AND state = 'VT'),
     (SELECT id FROM climber  WHERE first_name = 'Mallory' AND last_name = 'Malicious'),
     '2020-06-30',
     'http://badplace.net/malwareinfested/readme-if-you-dare.html'),
    ((SELECT id FROM mountain WHERE name = 'Katahdin, Baxter Peak' AND state = 'ME'),
     (SELECT id FROM climber  WHERE first_name = 'Trent' AND last_name = 'Trustworthy'),
     '2020-07-15',
     'What a great view!');
