Untitled

mail@pastecode.io avatarunknown
plain_text
22 days ago
1.9 kB
12
Indexable
Never
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');