Untitled

INSERT INTO account
VALUES ('A-101', 'Downtown', '500'),
       ('A-102', 'Perryridge', '400'),
       ('A-201', 'Brighton', '900'),
       ('A-215', 'Mianus', '700'),
       ('A-217', 'Brighton', '750'),
       ('A-222', 'Redwood', '700'),
       ('A-305', 'Round Hill', '350');


INSERT INTO branch
VALUES ('Brighton', 'Brooklyn', '7100000'),
       ('Downtown', 'Brooklyn', '9000000'),
       ('Mianus', 'Horseneck', '400000'),
       ('North Town', 'Rye', '3700000'),
       ('Perryridge', 'Bennington', '300000'),
       ('Pownal', 'Palo Alto', '2100000'),
       ('Redwood', 'Horseneck', '8000000'),
       ('Round Hill', 'Horseneck', '1700000');

INSERT INTO customer
VALUES
      ('Adams', 'Spring', 'Brooklyn'),
      ('Brooks', 'Senator', 'Putnam'),
      ('Curry', 'North', 'Woodside'),
      ('Glenn', 'Sand Hill', 'Harrison'),
      ('Green', 'Walnut', 'Stamford'),
      ('Hayes', 'Main', 'Princeton'),
      ('Johnson', 'Alma', 'Rye'),
      ('Jones', 'Main', 'Harrison'),
      ('Lindsay', 'Park', 'Bennington'),
      ('Smith', 'Turner', 'Palo Alto'),
      ('Williams', 'North', 'Stamford');

INSERT INTO depositor
VALUES
      ('Hayes', 'A-102'),
      ('Johnson', 'A-101'),
      ('Johnson', 'A-201'),
      ('Jones', 'A-217'),
      ('Lindsay', 'A-222'),
      ('Smith', 'A-215'),
      ('Turner', 'A-305');

INSERT INTO loan
VALUES
      ('L-11', 'Round Hill', '900'),
      ('L-14', 'Downtown', '1500'),
      ('L-15', 'Perryridge', '1500'),
      ('L-16', 'Perryridge', '1300'),
      ('L-17', 'Downtown', '1000'),
      ('L-23', 'Redwood', '2000'),
      ('L-93', 'Mianus', '500');

INSERT INTO borrower
VALUES
      ('Adams', 'L-16'),
      ('Curry', 'L-93'),
      ('Hayes', 'L-15'),
      ('Jackson', 'L-14'),
      ('Jones', 'L-17'),
      ('Smith', 'L-11'),
      ('Smith', 'L-23'),
      ('Williams', 'L-17');