Untitled

 avatar
Rohit143
plain_text
a year ago
2.1 kB
1
Indexable
Never
[08/09, 11:17 am] Mrugank Shirurkar VIIT (IT): INSERT INTO branch
 VALUES ('Brighton', 'Brooklyn', '7100000'),
              ('Downtown', 'Brooklyn', '9000000'),
              ('Mianus', 'Horseneck', '400000'),
              ('North Town', 'Rye', '3700000'),
('Perryridge','Horseneck','1700000'),
            ('Pownal','Bennington','300000'),
         ('Redwood','Palo Alto', '2100000'),
         ('Round Hill','Horseneck','8000000');
[08/09, 11:17 am] Mrugank Shirurkar VIIT (IT): 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');
[08/09, 11:17 am] Mrugank Shirurkar VIIT (IT): 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');
[08/09, 11:17 am] Mrugank Shirurkar VIIT (IT): 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');
[08/09, 11:17 am] Mrugank Shirurkar VIIT (IT): INSERT INTO customer
VALUES  ('Adams','Spring','Pittsfield'),
	('Brooks','Senator','Brooklyn'),
	('Curry','North','Rye'),
	('Glenn','Sand Hill','Woodside'),
	('Green','Walnut','Stamford'),
	('Hayes','Main','Harrison'),
	('Johnson','Alma','Palo Alto'),
	('Jones','Main','Harrison'),
	('Lindsay','Park','Pittsfield'),
	('Smith','North','Rye'),
	('Turner','Putnam','Stamford'),
	('Williams','Nassau','Princeton');
[08/09, 11:17 am] Mrugank Shirurkar VIIT (IT): INSERT INTO borrower
VALUES
      ('Adams', 'L-16'),
      ('Curry', 'L-93'),
      ('Hayes', 'L-15'),
      ('Jones', 'L-17'),
      ('Smith', 'L-11'),
      ('Smith', 'L-23'),
      ('Williams', 'L-17');