DROP TABLE IF EXISTS transaction;
DROP TABLE IF EXISTS account;
DROP TABLE IF EXISTS loan;
DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS employee;
DROP TABLE IF EXISTS branch;

CREATE TABLE branch(
branch_id SERIAL PRIMARY KEY,
branch_name VARCHAR(100),
address VARCHAR(200),
phone_number VARCHAR(13),
manager_id INT
);

CREATE TABLE employee(
employee_id SERIAL PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
position VARCHAR(100),
branch_id INT,
hire_date DATE,
salary NUMERIC(9, 2),
CONSTRAINT fk_employee_branch
	FOREIGN KEY (branch_id)
		REFERENCES branch(branch_id)
);

CREATE TABLE customer(
	customer_id SERIAL PRIMARY KEY,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	address VARCHAR(1000),
	dob DATE,
	phone_no VARCHAR(13),
	email VARCHAR(100),
	join_date DATE,
	branch_id INT,
	CONSTRAINT fk_customer_branch
		FOREIGN KEY (branch_id)
			REFERENCES branch(branch_id)
);


CREATE TABLE loan(
	loan_id SERIAL PRIMARY KEY,
	customer_id INT,
	loan_type VARCHAR(100),
	amount NUMERIC(9, 2),
	interest_rate NUMERIC(3, 2),
	start_date DATE,
	end_date DATE,
	status BOOLEAN,
	CONSTRAINT fk_loan_customer
		FOREIGN KEY (customer_id)
			REFERENCES customer(customer_id)
);


CREATE TABLE account(
	account_id SERIAL PRIMARY KEY,
	account_no INT,
	customer_id INT,
	account_type VARCHAR(100),
	balance NUMERIC(10, 2),
	date_opened DATE,
	CONSTRAINT fk_account_customer
		FOREIGN KEY (customer_id)
			REFERENCES customer(customer_id)
);

CREATE TABLE transaction(
	transaction_id SERIAL PRIMARY KEY,
	account_id INT,
	transaction_type VARCHAR(100),
	amount NUMERIC(7, 2),
	transaction_date DATE,
	description VARCHAR(1000),
	CONSTRAINT fk_transaction_account
		FOREIGN KEY (account_id)
			REFERENCES account(account_id)
);



insert into branch (branch_name, address, phone_number, manager_id) values ('Flowdesk', '6887 Ridgeview Hill', '3459443439', 29);
insert into branch (branch_name, address, phone_number, manager_id) values ('Domainer', '62 Northridge Street', '4674582622', 46);
insert into branch (branch_name, address, phone_number, manager_id) values ('Duobam', '330 Quincy Terrace', '3561896472', 29);
insert into branch (branch_name, address, phone_number, manager_id) values ('Y-find', '5484 Pleasure Parkway', '8909769947', 47);
insert into branch (branch_name, address, phone_number, manager_id) values ('Sonair', '19956 Morning Court', '1224811927', 14);


insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Suzanna', 'Hele', 'Senior Editor', 1, '2022-08-27', 451281.96);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Jannel', 'Bugby', 'Health Coach IV', 4, '2024-04-23', 498979.44);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Odetta', 'Solano', 'Librarian', 3, '2021-06-20', 374329.11);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Rivy', 'Biggerstaff', 'Financial Advisor', 1, '2020-07-30', 136891.75);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Lisabeth', 'Morstatt', 'Financial Advisor', 3, '2022-01-03', 376424.84);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Christen', 'Gannaway', 'Teacher', 4, '2023-09-13', 252787.05);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Fernanda', 'Purvis', 'VP Product Management', 4, '2021-09-26', 112456.98);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Gay', 'Ciubutaro', 'Nuclear Power Engineer', 5, '2023-08-26', 83821.17);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Katine', 'Doerr', 'Senior Developer', 1, '2022-03-02', 354442.3);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Arlyn', 'Scheffler', 'Staff Scientist', 1, '2021-09-08', 317921.22);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Mariette', 'Chart', 'Associate Professor', 1, '2023-10-16', 263305.34);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Jakie', 'Tunstall', 'Speech Pathologist', 3, '2022-03-29', 264785.18);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Constancia', 'Disney', 'Web Designer IV', 5, '2023-10-18', 217690.91);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Tobit', 'Braden', 'Payment Adjustment Coordinator', 5, '2022-01-08', 497961.18);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Beau', 'Mossbee', 'Paralegal', 2, '2022-07-31', 423441.52);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Kipper', 'Ickovic', 'Senior Editor', 2, '2024-07-25', 331387.74);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Burty', 'Alpine', 'Quality Control Specialist', 2, '2020-11-10', 129021.82);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Hillary', 'Izen', 'Computer Systems Analyst II', 4, '2023-01-12', 301892.8);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Norri', 'Duley', 'Office Assistant IV', 5, '2022-03-05', 474728.6);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Kyle', 'Stainburn', 'Software Engineer III', 2, '2020-03-22', 387976.64);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Lisabeth', 'Grubey', 'Accounting Assistant IV', 3, '2021-06-09', 185752.82);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Lura', 'McGraffin', 'Budget/Accounting Analyst II', 2, '2021-05-04', 171313.64);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Flemming', 'Corballis', 'Physical Therapy Assistant', 5, '2021-10-16', 136699.55);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Josephine', 'Mallia', 'Legal Assistant', 5, '2021-02-11', 153490.48);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Therine', 'Attenbarrow', 'Analyst Programmer', 4, '2021-07-28', 140789.02);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Reggy', 'Haugen', 'Marketing Manager', 5, '2024-09-03', 433673.23);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Bria', 'Luckman', 'Human Resources Manager', 4, '2021-04-27', 269646.25);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Klemens', 'Thrower', 'Media Manager IV', 2, '2023-02-07', 366224.97);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Yolane', 'Carrigan', 'Analyst Programmer', 4, '2020-01-16', 479361.97);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Max', 'Tillard', 'VP Quality Control', 4, '2022-05-26', 430544.72);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Carissa', 'Rishman', 'Electrical Engineer', 2, '2022-07-29', 389196.11);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Bale', 'Mattea', 'General Manager', 4, '2024-11-03', 146522.71);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Markus', 'Sevin', 'Structural Engineer', 3, '2020-09-04', 158907.08);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Ina', 'Woolf', 'Marketing Assistant', 5, '2021-10-25', 266097.59);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Bridie', 'Leasor', 'Graphic Designer', 5, '2024-05-16', 272150.68);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Kristan', 'Morrice', 'Software Consultant', 3, '2024-01-03', 357742.51);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Myrna', 'Haglington', 'Design Engineer', 2, '2020-08-28', 41894.45);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Woodman', 'Maddox', 'Administrative Assistant III', 3, '2024-03-06', 409982.83);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Jeanette', 'Conville', 'Cost Accountant', 3, '2021-05-06', 134642.47);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Artair', 'Kilner', 'Mechanical Systems Engineer', 3, '2021-06-18', 337321.42);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Kermie', 'Peevor', 'Account Executive', 3, '2024-10-16', 328087.28);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Marketa', 'Delf', 'Librarian', 2, '2024-03-30', 191627.61);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Tallou', 'Domingues', 'Engineer I', 2, '2023-05-23', 339272.13);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Aviva', 'Poluzzi', 'Help Desk Operator', 4, '2022-11-26', 179167.81);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Indira', 'Gillfillan', 'Senior Cost Accountant', 3, '2022-05-14', 178758.58);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Arden', 'Giottoi', 'Senior Sales Associate', 2, '2021-12-01', 81368.96);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Lavina', 'Gravy', 'Payment Adjustment Coordinator', 1, '2020-09-06', 334931.25);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Veradis', 'Munn', 'Engineer I', 4, '2020-02-16', 285355.34);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Palmer', 'Lohan', 'Project Manager', 2, '2024-04-06', 98815.47);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Alta', 'Cellier', 'Help Desk Technician', 3, '2020-04-14', 218553.39);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Jana', 'Bortoletti', 'Assistant Manager', 3, '2023-04-06', 329005.9);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Morlee', 'Rahlof', 'Graphic Designer', 2, '2023-11-16', 32341.0);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Karleen', 'Jeffery', 'Senior Editor', 5, '2021-11-26', 109710.96);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Simone', 'Briskey', 'GIS Technical Architect', 1, '2021-11-11', 487466.04);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Everett', 'Bendik', 'Quality Engineer', 3, '2021-02-25', 464306.55);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Codee', 'Paddie', 'Recruiting Manager', 1, '2020-12-09', 477917.97);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Albina', 'Dumphy', 'Dental Hygienist', 5, '2022-04-25', 243690.11);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Dannie', 'McGiffin', 'Safety Technician IV', 4, '2021-03-06', 459456.52);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Dacia', 'Mahedy', 'Electrical Engineer', 2, '2023-03-21', 96758.22);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Ward', 'Lough', 'Social Worker', 1, '2021-02-04', 191570.68);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Mirabella', 'Ferney', 'Payment Adjustment Coordinator', 1, '2023-04-08', 227234.56);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Bogart', 'Philpots', 'Account Executive', 5, '2024-06-13', 303929.81);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Lewie', 'Toplis', 'Desktop Support Technician', 3, '2023-10-22', 396020.8);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Debor', 'Lambersen', 'General Manager', 3, '2022-01-27', 143885.75);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Cosme', 'Chippendale', 'Account Coordinator', 4, '2023-04-04', 41650.05);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Gunner', 'Maddaford', 'Pharmacist', 3, '2020-07-04', 177853.17);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Rivalee', 'Caps', 'General Manager', 5, '2022-07-14', 281287.95);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Emmerich', 'Kubat', 'Environmental Specialist', 3, '2022-10-05', 154978.24);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Gothart', 'Ogilby', 'Financial Advisor', 2, '2022-08-11', 135153.7);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Nora', 'Antonin', 'Editor', 5, '2020-12-17', 287216.23);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Ferrel', 'Huckster', 'Electrical Engineer', 3, '2024-01-09', 260763.52);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Lauri', 'Brotherheed', 'Account Representative I', 1, '2023-11-18', 362916.59);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Theresina', 'Heaney', 'Account Representative II', 3, '2024-08-10', 376529.66);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Ranice', 'McMeekin', 'Safety Technician IV', 2, '2022-03-25', 451515.92);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Katheryn', 'Lathy', 'Clinical Specialist', 5, '2022-04-21', 104182.94);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Melita', 'Breeder', 'Geologist I', 3, '2024-01-15', 150588.17);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Siegfried', 'Murrells', 'Help Desk Operator', 2, '2022-03-27', 218220.78);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Linette', 'Ghent', 'VP Product Management', 1, '2023-01-31', 352891.68);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Faunie', 'Red', 'Senior Developer', 1, '2024-07-24', 30308.72);
insert into employee (first_name, last_name, position, branch_id, hire_date, salary) values ('Abigale', 'Enstone', 'Civil Engineer', 2, '2023-03-11', 318358.69);

SELECT*FROM employee;

insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Toddie', 'Adrian', '07 Caliangt Junction', '1952-03-30', '3864413075', 'tadrian0@discovery.com', '2004-03-12', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Everard', 'McCudden', '216 Haas Terrace', '1942-06-02', '9709698679', 'emccudden1@topsy.com', '2006-10-12', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Ivie', 'Shotboulte', '677 Corben Center', '1968-12-11', '8102908132', 'ishotboulte2@tripod.com', '2003-11-02', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Danice', 'Willson', '0 Warner Hill', '1970-02-06', '3845434808', 'dwillson3@admin.ch', '2018-09-23', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Natty', 'Wyldbore', '5 Marquette Point', '1965-08-13', '2663912227', 'nwyldbore4@ustream.tv', '2014-10-31', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Jerrome', 'Frend', '3 Union Park', '1986-11-21', '2591955362', 'jfrend5@1und1.de', '2020-07-03', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Bastien', 'Dundridge', '56140 1st Road', '1954-06-22', '1047779596', 'bdundridge6@hp.com', '2020-07-14', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Tandie', 'Barks', '83 Doe Crossing Place', '1956-01-11', '2798696749', 'tbarks7@slideshare.net', '2021-10-30', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Trev', 'Amdohr', '445 Graedel Terrace', '1911-01-08', '2839477319', 'tamdohr8@disqus.com', '2024-01-27', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Pinchas', 'Face', '707 Luster Trail', '1967-09-16', '4598922981', 'pface9@huffingtonpost.com', '2013-07-21', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Jan', 'Esberger', '4 Division Road', '1979-12-22', '8016127211', 'jesbergera@slideshare.net', '2010-11-13', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Shurwood', 'Minney', '6 Hooker Place', '1974-07-19', '7819390355', 'sminneyb@tumblr.com', '2009-09-07', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Jemimah', 'Fellman', '4577 Vermont Alley', '1955-07-30', '8323652213', 'jfellmanc@usatoday.com', '2014-09-29', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Merill', 'Athersmith', '975 Waywood Plaza', '1922-09-02', '9067155417', 'mathersmithd@unc.edu', '2020-12-20', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Killie', 'Culpen', '78 Nancy Hill', '1946-08-07', '6084523347', 'kculpene@cdc.gov', '2014-12-16', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Aristotle', 'Lyptrade', '85 Golf Trail', '1946-08-05', '3761527499', 'alyptradef@nymag.com', '2002-01-23', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Simonette', 'Hesse', '27740 Starling Avenue', '1981-12-29', '6985879034', 'shesseg@ebay.co.uk', '2013-06-15', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Denni', 'Kleisle', '6047 Fisk Alley', '1948-02-23', '2539694610', 'dkleisleh@a8.net', '2012-03-16', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Janina', 'Holyland', '1372 Macpherson Pass', '1916-11-18', '6422983914', 'jholylandi@engadget.com', '2009-08-20', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Jammal', 'Scattergood', '974 Declaration Hill', '1917-09-29', '2971938316', 'jscattergoodj@wunderground.com', '2020-07-16', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Melli', 'Seys', '7722 Chive Crossing', '1914-09-07', '9971689107', 'mseysk@forbes.com', '2001-07-27', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Mendie', 'Branigan', '71 Dovetail Plaza', '1966-06-15', '5914137740', 'mbraniganl@histats.com', '2015-03-09', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Shelli', 'Breem', '2 Anzinger Way', '1943-03-22', '2463064966', 'sbreemm@chron.com', '2010-09-03', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Mickie', 'McKintosh', '79 Spenser Parkway', '1970-03-30', '7659820384', 'mmckintoshn@pbs.org', '2024-06-09', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Garrard', 'Hynard', '13 Jenifer Junction', '1937-04-07', '3744342151', 'ghynardo@aol.com', '2000-10-28', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Enid', 'Wakeley', '2174 Clove Court', '1983-03-11', '1109517873', 'ewakeleyp@amazon.com', '2003-07-08', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Gabriell', 'Housbey', '1993 Pleasure Crossing', '1973-10-07', '8807988071', 'ghousbeyq@ask.com', '2008-05-20', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Dorise', 'Dumper', '7 Maple Lane', '1931-03-26', '8733224483', 'ddumperr@plala.or.jp', '2013-04-22', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Ardyth', 'Burnsell', '70 Clyde Gallagher Pass', '1960-08-17', '9368267313', 'aburnsells@furl.net', '2005-01-28', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Adella', 'Mark', '27 Del Sol Drive', '1995-08-07', '7184077065', 'amarkt@webeden.co.uk', '2020-10-23', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Jasun', 'Heggison', '78 Sullivan Crossing', '2002-01-27', '2304220106', 'jheggisonu@deviantart.com', '2010-07-23', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Glen', 'Sebborn', '3 Arapahoe Court', '1980-10-03', '2631950281', 'gsebbornv@reference.com', '2019-08-26', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Yevette', 'Groucock', '6 Steensland Drive', '1915-11-10', '2835628867', 'ygroucockw@cargocollective.com', '2017-04-04', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Abie', 'Schoales', '561 Evergreen Park', '1929-12-12', '4294113868', 'aschoalesx@reverbnation.com', '2006-01-06', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Aviva', 'Headly', '6016 Eagan Place', '1968-05-07', '7852487168', 'aheadlyy@ehow.com', '2020-08-27', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Daisy', 'Bust', '8120 Carioca Junction', '1982-10-15', '6842218213', 'dbustz@blogger.com', '2017-11-01', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Durante', 'Rubenfeld', '4883 Atwood Park', '1961-11-23', '5838780522', 'drubenfeld10@goodreads.com', '2012-07-17', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Abbot', 'Caudrey', '1899 Burrows Junction', '1962-10-03', '4836735254', 'acaudrey11@gmpg.org', '2001-01-27', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Dulcie', 'Shambrooke', '77 Caliangt Hill', '1920-07-11', '3528895100', 'dshambrooke12@t-online.de', '2004-06-12', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Kath', 'Morteo', '14838 2nd Center', '1987-03-21', '6088651147', 'kmorteo13@miibeian.gov.cn', '2015-01-08', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Olympia', 'Ogdahl', '88305 North Terrace', '1999-02-22', '8857955053', 'oogdahl14@amazonaws.com', '2016-07-12', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Kirsteni', 'Koch', '7782 La Follette Crossing', '1944-07-24', '8862921069', 'kkoch15@howstuffworks.com', '2017-09-23', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Augustus', 'Szymanowicz', '51 South Terrace', '1918-11-08', '1185749601', 'aszymanowicz16@google.com.hk', '2002-04-05', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Archibaldo', 'Ambrodi', '65929 Anniversary Court', '2004-07-11', '5267296420', 'aambrodi17@ihg.com', '2014-03-02', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Micky', 'Scritch', '1 Prentice Place', '1983-11-15', '4568407133', 'mscritch18@rakuten.co.jp', '2008-01-09', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Cornie', 'Timberlake', '1 Independence Point', '2006-06-13', '3983942935', 'ctimberlake19@webnode.com', '2014-04-23', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Saundra', 'Snaden', '22 Heffernan Place', '2004-11-29', '5292937979', 'ssnaden1a@theglobeandmail.com', '2010-12-23', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Haskel', 'Grout', '41138 Melody Lane', '1926-10-26', '4356028136', 'hgrout1b@so-net.ne.jp', '2003-01-30', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Townie', 'Jupp', '4 Nova Place', '1925-09-17', '4152037617', 'tjupp1c@craigslist.org', '2011-09-16', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Dorie', 'Simkiss', '6178 Porter Plaza', '1990-08-01', '2336422422', 'dsimkiss1d@gravatar.com', '2012-02-24', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Asia', 'Pendle', '4084 Kenwood Alley', '1969-11-30', '9045581355', 'apendle1e@sogou.com', '2021-10-19', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Lynnelle', 'Steinham', '864 Logan Avenue', '1926-08-29', '2298733264', 'lsteinham1f@blogs.com', '2009-01-22', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Cosette', 'Philliskirk', '43 Susan Lane', '1959-10-16', '2498558838', 'cphilliskirk1g@ft.com', '2007-06-21', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Reese', 'Remington', '2134 Kedzie Court', '1966-08-02', '3949745624', 'rremington1h@sfgate.com', '2005-08-25', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Derick', 'Clack', '1825 Butternut Avenue', '1966-05-30', '1387321322', 'dclack1i@macromedia.com', '2023-05-27', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Bessie', 'Callf', '81 Orin Park', '1981-03-04', '7459065870', 'bcallf1j@booking.com', '2024-08-05', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Fair', 'McCadden', '96 Main Terrace', '1911-01-17', '9165602067', 'fmccadden1k@nifty.com', '2021-08-22', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Findley', 'Clapperton', '2 Toban Drive', '1920-02-04', '7352126049', 'fclapperton1l@nps.gov', '2004-04-08', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Lilah', 'McGilben', '465 Riverside Parkway', '1931-11-12', '7947268862', 'lmcgilben1m@howstuffworks.com', '2010-07-14', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Olivie', 'Able', '763 Reinke Hill', '1977-05-21', '7294520261', 'oable1n@lulu.com', '2024-02-28', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Bernadette', 'Maccrae', '4 Orin Lane', '2002-07-05', '6284002672', 'bmaccrae1o@sogou.com', '2023-07-24', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Cobb', 'Slemmonds', '79037 Kipling Junction', '1998-05-02', '5438672322', 'cslemmonds1p@parallels.com', '2012-11-08', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Nicolas', 'Strevens', '5 Fallview Pass', '1955-06-11', '7611241100', 'nstrevens1q@ucoz.ru', '2002-11-17', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Cosme', 'Clausson', '95 Artisan Way', '1947-02-19', '6905762445', 'cclausson1r@baidu.com', '2004-06-28', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Karalee', 'Perillio', '86 Pawling Circle', '1928-08-27', '9329401548', 'kperillio1s@usa.gov', '2020-10-01', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Charis', 'Kilbey', '91713 Bayside Park', '1949-01-04', '3953211542', 'ckilbey1t@example.com', '2011-07-11', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Uriel', 'MacSkeagan', '6126 Bluejay Park', '1939-05-17', '2772838332', 'umacskeagan1u@newyorker.com', '2022-10-20', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Georgie', 'Coburn', '8041 Delladonna Lane', '1975-04-23', '5726727309', 'gcoburn1v@dyndns.org', '2007-09-25', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Maryanne', 'Urvoy', '880 Fisk Plaza', '1920-03-28', '2081462234', 'murvoy1w@ovh.net', '2018-04-04', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Win', 'Bourgaize', '552 Lien Road', '1908-04-13', '6525253624', 'wbourgaize1x@smh.com.au', '2023-12-12', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Darcy', 'Swaisland', '42725 Rockefeller Hill', '1979-11-26', '3184798135', 'dswaisland1y@jimdo.com', '2002-10-28', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Alfredo', 'Raiman', '558 Fair Oaks Hill', '1984-02-29', '3044233539', 'araiman1z@umich.edu', '2007-04-26', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Maude', 'Lammenga', '89034 Express Parkway', '1911-11-09', '6043467527', 'mlammenga20@buzzfeed.com', '2005-06-05', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Patrizio', 'Othick', '15 John Wall Plaza', '1944-09-11', '2099676301', 'pothick21@seesaa.net', '2007-11-28', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Reggie', 'Ovill', '66 Morning Terrace', '1983-06-18', '6088738192', 'rovill22@dion.ne.jp', '2017-06-02', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Estella', 'Norcliff', '71499 Becker Center', '1993-09-14', '6639372917', 'enorcliff23@wordpress.com', '2011-07-21', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Doloritas', 'Huard', '79577 Bayside Place', '1919-10-07', '9837615905', 'dhuard24@de.vu', '2024-02-28', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Felicle', 'Watsam', '2365 Novick Court', '2006-01-16', '6204976393', 'fwatsam25@washington.edu', '2008-03-19', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Talbot', 'Ferencz', '54 Roxbury Circle', '1956-07-27', '8526568187', 'tferencz26@gmpg.org', '2019-08-09', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Enriqueta', 'Meininking', '81973 Loftsgordon Center', '1921-07-31', '2199539528', 'emeininking27@cafepress.com', '2010-04-12', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Gwenneth', 'Gamon', '59 Fisk Way', '1954-06-20', '9043944619', 'ggamon28@pen.io', '2024-06-02', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Cornie', 'Goldspink', '601 East Court', '1944-12-26', '7462254983', 'cgoldspink29@stanford.edu', '2003-08-08', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Hank', 'Artinstall', '1480 Russell Hill', '1944-08-31', '3697368506', 'hartinstall2a@yahoo.com', '2002-01-04', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Ambros', 'Label', '8 Valley Edge Point', '1922-08-15', '2457895064', 'alabel2b@free.fr', '2022-02-24', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Janeva', 'Pitcaithley', '8663 South Street', '1996-05-07', '6028789860', 'jpitcaithley2c@mtv.com', '2021-11-19', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Bev', 'Cardoo', '36 John Wall Parkway', '1992-08-31', '5453020145', 'bcardoo2d@yandex.ru', '2018-07-27', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Gordie', 'Rockhill', '20957 Prentice Road', '1955-11-02', '6988131961', 'grockhill2e@netvibes.com', '2010-05-16', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Anselma', 'Sykes', '7022 Truax Circle', '1948-06-21', '9828798440', 'asykes2f@over-blog.com', '2023-06-10', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Emmett', 'Parriss', '3 Emmet Circle', '1999-10-25', '6452264293', 'eparriss2g@upenn.edu', '2019-08-10', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Alvera', 'Marner', '1049 Marcy Way', '1918-05-20', '6574715843', 'amarner2h@wunderground.com', '2010-04-18', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Mandi', 'Izzard', '463 Badeau Alley', '1965-04-26', '4908620375', 'mizzard2i@fotki.com', '2015-08-20', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Joyce', 'Adney', '96724 Truax Terrace', '1977-12-24', '2393274513', 'jadney2j@flickr.com', '2021-05-29', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Pru', 'Deare', '434 Center Alley', '1920-12-02', '1403246393', 'pdeare2k@google.fr', '2011-12-27', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Mavis', 'Airey', '0662 Holy Cross Lane', '1937-10-23', '2072759759', 'mairey2l@desdev.cn', '2021-12-23', 5);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Bayard', 'Skene', '0653 Fieldstone Crossing', '1932-04-11', '3299543097', 'bskene2m@sitemeter.com', '2020-08-28', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Aviva', 'Penella', '6066 Sutteridge Hill', '1983-09-10', '7341478563', 'apenella2n@rediff.com', '2020-09-10', 1);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Ferguson', 'Iacoboni', '16843 Helena Junction', '1923-10-19', '8962872933', 'fiacoboni2o@plala.or.jp', '2003-12-22', 4);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Alanson', 'Wicher', '64 Surrey Hill', '2001-07-05', '9873534920', 'awicher2p@bloglovin.com', '2012-03-13', 3);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Ivory', 'Mannix', '03625 Brentwood Point', '1986-08-13', '8338273974', 'imannix2q@chicagotribune.com', '2018-01-19', 2);
insert into customer (first_name, last_name, address, dob, phone_no, email, join_date, branch_id) values ('Dorotea', 'Widger', '956 Anniversary Plaza', '1959-07-26', '8125163917', 'dwidger2r@kickstarter.com', '2017-12-01', 3);

SELECT*FROM customer

insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (19, 'Ford', 6625625.67, 1.19, '2022-07-10', '2023-06-27', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (33, 'Mazda', 1528834.23, 8.56, '2022-04-25', '2023-08-27', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (59, 'Chevrolet', 5059324.85, 2.01, '2020-05-13', '2023-08-03', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (79, 'Ford', 8005690.2, 6.16, '2021-02-23', '2023-03-23', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (61, 'Toyota', 554922.85, 4.17, '2022-07-17', '2024-03-01', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (38, 'Lincoln', 5761815.13, 6.43, '2021-03-08', '2024-03-06', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (83, 'Kia', 3209775.25, 3.09, '2020-04-01', '2023-12-22', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (8, 'Ford', 5992209.24, 1.06, '2020-12-19', '2023-06-20', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (47, 'GMC', 3874032.5, 7.63, '2022-11-07', '2024-03-31', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (68, 'Pontiac', 4786800.45, 6.5, '2020-01-30', '2023-03-07', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (53, 'Lexus', 7605875.96, 6.98, '2021-05-16', '2022-11-26', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (19, 'Lincoln', 5312411.55, 8.76, '2021-03-08', '2024-06-09', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (50, 'Mitsubishi', 523830.15, 1.07, '2020-12-07', '2024-06-04', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (46, 'Ford', 406033.24, 8.71, '2020-08-21', '2023-04-18', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (64, 'Audi', 4672857.02, 2.24, '2020-02-11', '2023-06-25', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (79, 'Chevrolet', 4311446.93, 7.12, '2020-11-23', '2023-04-14', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (98, 'Volkswagen', 3917676.59, 1.31, '2021-01-04', '2023-10-30', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (21, 'Chevrolet', 1206257.0, 2.12, '2022-10-29', '2024-10-16', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (6, 'Audi', 2486828.91, 3.07, '2022-10-04', '2023-05-12', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (51, 'Chevrolet', 5236262.44, 3.84, '2020-10-03', '2024-10-22', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (99, 'Mercury', 3679975.32, 4.84, '2020-10-27', '2023-12-06', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (16, 'GMC', 2879447.99, 8.18, '2022-09-27', '2024-06-05', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (36, 'Volkswagen', 5626540.62, 7.04, '2022-09-25', '2024-04-26', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (78, 'Suzuki', 4205519.57, 4.85, '2020-09-28', '2023-08-01', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (96, 'Chevrolet', 8883891.01, 2.43, '2022-01-06', '2023-01-22', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (23, 'BMW', 5170927.65, 5.63, '2021-01-20', '2023-10-31', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (69, 'Rambler', 2729606.22, 8.59, '2021-10-16', '2024-10-13', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (84, 'Lexus', 8105707.44, 8.36, '2022-06-01', '2024-07-11', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (23, 'Audi', 7078785.44, 2.78, '2022-09-16', '2023-06-29', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (87, 'Hyundai', 240183.31, 8.77, '2020-08-01', '2024-02-20', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (85, 'Mercedes-Benz', 3217379.62, 3.17, '2020-01-04', '2024-07-19', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (89, 'Pontiac', 5570495.24, 4.64, '2022-05-01', '2023-01-28', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (39, 'Volkswagen', 7719519.77, 2.55, '2022-02-15', '2023-04-17', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (87, 'Mercedes-Benz', 2541266.15, 8.03, '2021-09-23', '2024-03-20', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (96, 'Mercedes-Benz', 1782294.07, 3.73, '2022-09-04', '2023-11-12', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (29, 'Ford', 924701.25, 8.3, '2022-09-08', '2024-01-09', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (81, 'Ford', 5684865.84, 6.39, '2021-07-30', '2024-09-26', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (64, 'Mazda', 1359774.18, 6.84, '2022-02-04', '2023-08-23', false);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (79, 'Dodge', 9246029.49, 2.9, '2022-09-01', '2024-10-12', true);
insert into loan (customer_id, loan_type, amount, interest_rate, start_date, end_date, status) values (4, 'GMC', 8204857.44, 4.62, '2022-05-27', '2024-08-04', false);

SELECT*FROM loan