mock_data.sql

INSERT INTO Categories (CategoryName) VALUES ('Yard');
INSERT INTO Categories (CategoryName) VALUES ('Nothing');
INSERT INTO Categories (CategoryName) VALUES ('This');
INSERT INTO Categories (CategoryName) VALUES ('Say');
INSERT INTO Categories (CategoryName) VALUES ('Order');
INSERT INTO Categories (CategoryName) VALUES ('Fight');
INSERT INTO Categories (CategoryName) VALUES ('Ask');
INSERT INTO Categories (CategoryName) VALUES ('Success');
INSERT INTO Categories (CategoryName) VALUES ('Guy');
INSERT INTO Categories (CategoryName) VALUES ('Himself');
INSERT INTO Authors (FirstName, LastName) VALUES ('Adam', 'Boone');
INSERT INTO Authors (FirstName, LastName) VALUES ('Michael', 'Hutchinson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Bradley', 'Jones');
INSERT INTO Authors (FirstName, LastName) VALUES ('Linda', 'Price');
INSERT INTO Authors (FirstName, LastName) VALUES ('Tina', 'Howard');
INSERT INTO Authors (FirstName, LastName) VALUES ('Kayla', 'Castro');
INSERT INTO Authors (FirstName, LastName) VALUES ('Patricia', 'Garcia');
INSERT INTO Authors (FirstName, LastName) VALUES ('Terri', 'Weaver');
INSERT INTO Authors (FirstName, LastName) VALUES ('Mary', 'Ellis');
INSERT INTO Authors (FirstName, LastName) VALUES ('Andrew', 'Foster');
INSERT INTO Authors (FirstName, LastName) VALUES ('Megan', 'Johnson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Frank', 'White');
INSERT INTO Authors (FirstName, LastName) VALUES ('Nicole', 'Dalton');
INSERT INTO Authors (FirstName, LastName) VALUES ('David', 'Anderson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Natalie', 'Frank');
INSERT INTO Authors (FirstName, LastName) VALUES ('Shelley', 'Klein');
INSERT INTO Authors (FirstName, LastName) VALUES ('Kevin', 'King');
INSERT INTO Authors (FirstName, LastName) VALUES ('James', 'Sherman');
INSERT INTO Authors (FirstName, LastName) VALUES ('William', 'Tran');
INSERT INTO Authors (FirstName, LastName) VALUES ('Ebony', 'Green');
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Avoid tonight ever', '978-1-4092-2085-5', 'Kemp-Owens', 1980, 596, 4, 4, 5);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Up only', '978-1-169-14817-8', 'Schmidt-King', 2010, 268, 1, 1, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Game staff', '978-0-372-00339-7', 'Zavala-Weeks', 2013, 765, 2, 2, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Room maybe', '978-1-224-64966-4', 'Smith PLC', 1983, 577, 8, 8, 9);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Six significant within', '978-0-08-958217-8', 'Guzman-Taylor', 2018, 281, 7, 7, 5);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Key purpose', '978-1-5396-4735-5', 'Perry-Faulkner', 2004, 603, 7, 7, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Life represent kitchen', '978-0-7796-5339-3', 'Rodriguez Ltd', 2012, 675, 5, 5, 9);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Teacher type suggest', '978-0-902208-41-4', 'Fox, Sullivan and Lynch', 1998, 348, 10, 10, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Particularly difficult', '978-1-130-32111-1', 'Cunningham, Lee and Wood', 1987, 644, 1, 1, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('System ground', '978-0-424-85946-0', 'Contreras Ltd', 2008, 151, 3, 3, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Moment work', '978-0-420-21432-4', 'Moss LLC', 2012, 542, 7, 7, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Fight rest senior', '978-1-4255-3423-3', 'Parker, Daniels and Dodson', 1993, 326, 6, 6, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Enter so prepare', '978-0-535-65041-3', 'Murphy-Gutierrez', 2011, 696, 3, 3, 5);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Factor option', '978-0-03-338079-9', 'Stewart, Lee and Randolph', 2005, 184, 4, 4, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Blood', '978-0-08-158846-8', 'Burnett, Zimmerman and Rodriguez', 1997, 600, 9, 9, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Many available reflect', '978-0-8292-7868-2', 'Green-Wolf', 1980, 134, 6, 6, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Among event but', '978-1-336-54758-2', 'Mcclain-Dixon', 1993, 393, 3, 3, 8);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Speech do any', '978-1-261-60829-7', 'Anderson LLC', 2002, 118, 6, 6, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('For her', '978-1-998255-39-9', 'Miller, Thomas and Smith', 1997, 659, 5, 5, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Into fly', '978-0-922358-33-5', 'Forbes and Sons', 1981, 497, 9, 9, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Almost world either', '978-0-445-93778-9', 'Spears, Mejia and Harrison', 1989, 432, 7, 7, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Little threat', '978-1-70871-976-0', 'White-Lane', 1982, 449, 9, 9, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Media next enough', '978-0-286-99966-3', 'Perez LLC', 2006, 374, 4, 4, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Environmental herself develop', '978-0-7870-4949-2', 'Owens-Shelton', 2020, 426, 1, 1, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Option kind rate', '978-1-01-463390-3', 'Lopez-Newman', 1990, 252, 3, 3, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Listen modern especially value', '978-1-08-527669-6', 'Armstrong-Davis', 1997, 357, 5, 5, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Produce black off', '978-1-07-764194-5', 'Lewis Inc', 1981, 525, 9, 9, 8);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Exist miss', '978-0-614-43545-0', 'Colon-Mendez', 2002, 226, 9, 9, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Value art', '978-0-8096-6532-7', 'Phillips, Higgins and Thomas', 2004, 405, 8, 8, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Threat rise', '978-1-84993-627-9', 'Davenport, Hall and Sellers', 1995, 329, 9, 9, 4);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (26, 3);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (28, 9);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (4, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (29, 5);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (8, 8);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (4, 19);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (6, 2);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (3, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (25, 20);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (18, 19);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (29, 8);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (5, 14);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (12, 10);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (27, 16);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (27, 18);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (10, 2);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (3, 2);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (23, 17);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (28, 20);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (12, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (12, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (27, 18);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (29, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (3, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (21, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (22, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (7, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (3, 4);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (11, 18);
INSERT INTO Staff (FirstName, LastName) VALUES ('Mark', 'Jimenez');
INSERT INTO Staff (FirstName, LastName) VALUES ('Elizabeth', 'Hernandez');
INSERT INTO Staff (FirstName, LastName) VALUES ('April', 'Wheeler');
INSERT INTO Staff (FirstName, LastName) VALUES ('Kimberly', 'Mitchell');
INSERT INTO Staff (FirstName, LastName) VALUES ('Laurie', 'Miller');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Kimberly', 'Diaz', 'robertakelly@molina.biz', '(512)917-8334x28766', '380 Haley Views Suite 157 New Stephaniebury, WY 65966', '2025-06-05', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Courtney', 'Suarez', 'beltrancindy@riley.info', '+1-555-139-1209x625', 'USNS Brown FPO AP 56887', '2024-06-05', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Ashley', 'Carroll', 'gleonard@yahoo.com', '001-170-949-2676x882', 'Unit 6903 Box 5032 DPO AE 12228', '2023-07-27', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Bethany', 'Morris', 'shawn09@yahoo.com', '+1-192-316-2397x3784', '163 Tyler Meadow Kelliefort, UT 11911', '2024-08-25', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Crystal', 'Williamson', 'greed@myers.com', '+1-573-684-1712x589', '6674 Martin Rapid Suite 430 West Craigmouth, HI 50704', '2025-03-29', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('David', 'Alvarez', 'christopherjones@hotmail.com', '220.962.3848', '8829 Reyes Dam Suite 847 Helenmouth, LA 16896', '2024-02-17', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Matthew', 'Adkins', 'kduke@meyer-hudson.info', '+1-144-320-4551x42943', '900 Santiago Valley Suite 414 Davidstad, MO 53204', '2024-10-15', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Jacob', 'Lucas', 'iyork@hotmail.com', '136-660-9556', '53295 Jo Ways Ellisonmouth, ND 81583', '2024-02-08', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Maria', 'Rubio', 'stewartannette@khan.net', '455-154-4472x6800', '924 Mark River West Glenville, AK 44315', '2025-02-22', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Christina', 'Harrison', 'lekelly@henry-brown.com', '020-744-1514x537', '6153 Lisa Knoll Suite 974 East Christopherburgh, IN 25285', '2024-06-09', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Jonathan', 'Walker', 'mluna@yahoo.com', '558.851.0224', '145 Ward Rapids Karenfort, NV 08571', '2025-01-21', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Kenneth', 'Oliver', 'howardanthony@hotmail.com', '(589)842-5578', '11214 Raymond Bridge Apt. 814 East Travis, CT 14722', '2024-04-27', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Michele', 'Riggs', 'vhodge@nunez.info', '980-823-6661x277', 'Unit 1560 Box 7207 DPO AP 39781', '2023-08-26', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('James', 'Haynes', 'melissasnyder@jones-trujillo.org', '001-780-022-0752', '78008 Sanchez Parks Suite 216 Jasonburgh, ND 98934', '2024-09-04', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('James', 'Donovan', 'zmorales@hotmail.com', '8849341570', '3870 Katherine Orchard Michaelside, CO 43301', '2025-05-31', 'Standard');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 11, 1, '2025-06-16', '2025-06-16', NULL, 7.52, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (3, 11, 4, '2025-06-16', '2025-06-16', NULL, 8.98, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 22, 3, '2025-06-16', '2025-06-16', NULL, 15.39, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (15, 23, 2, '2025-06-16', '2025-06-16', NULL, 14.3, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (7, 18, 2, '2025-06-16', '2025-06-16', NULL, 10.42, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (10, 11, 5, '2025-06-16', '2025-06-16', NULL, 2.32, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 29, 1, '2025-06-16', '2025-06-16', NULL, 2.37, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (8, 16, 1, '2025-06-16', '2025-06-16', NULL, 16.86, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (13, 6, 1, '2025-06-16', '2025-06-16', NULL, 9.29, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (9, 10, 3, '2025-06-16', '2025-06-16', NULL, 2.12, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (15, 11, 4, '2025-06-16', '2025-06-16', NULL, 1.78, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 19, 4, '2025-06-16', '2025-06-16', NULL, 2.24, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (8, 5, 5, '2025-06-16', '2025-06-16', NULL, 11.94, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (11, 19, 2, '2025-06-16', '2025-06-16', NULL, 1.88, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (3, 30, 5, '2025-06-16', '2025-06-16', NULL, 11.51, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (5, 13, 4, '2025-06-16', '2025-06-16', NULL, 0.14, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 29, 2, '2025-06-16', '2025-06-16', NULL, 11.34, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (7, 16, 3, '2025-06-16', '2025-06-16', NULL, 16.1, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 6, 3, '2025-06-16', '2025-06-16', NULL, 3.95, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 1, 2, '2025-06-16', '2025-06-16', NULL, 6.7, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (15, 17, 3, '2025-06-16', '2025-06-16', NULL, 19.5, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (7, 14, 4, '2025-06-16', '2025-06-16', NULL, 5.16, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (7, 20, 2, '2025-06-16', '2025-06-16', NULL, 8.65, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 30, 2, '2025-06-16', '2025-06-16', NULL, 13.47, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (11, 27, 2, '2025-06-16', '2025-06-16', NULL, 0.23, 'Active');
INSERT INTO Categories (CategoryName) VALUES ('Away');
INSERT INTO Categories (CategoryName) VALUES ('Cut');
INSERT INTO Categories (CategoryName) VALUES ('Word');
INSERT INTO Categories (CategoryName) VALUES ('Team');
INSERT INTO Categories (CategoryName) VALUES ('Hear');
INSERT INTO Categories (CategoryName) VALUES ('Old');
INSERT INTO Categories (CategoryName) VALUES ('Republican');
INSERT INTO Categories (CategoryName) VALUES ('Save');
INSERT INTO Categories (CategoryName) VALUES ('Weight');
INSERT INTO Categories (CategoryName) VALUES ('Threat');
INSERT INTO Authors (FirstName, LastName) VALUES ('Mark', 'Freeman');
INSERT INTO Authors (FirstName, LastName) VALUES ('Jordan', 'Manning');
INSERT INTO Authors (FirstName, LastName) VALUES ('Brian', 'Wilson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Dawn', 'Simon');
INSERT INTO Authors (FirstName, LastName) VALUES ('Beth', 'Parker');
INSERT INTO Authors (FirstName, LastName) VALUES ('Brianna', 'Knight');
INSERT INTO Authors (FirstName, LastName) VALUES ('Jonathan', 'Payne');
INSERT INTO Authors (FirstName, LastName) VALUES ('Edward', 'Johnson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Mark', 'Alvarado');
INSERT INTO Authors (FirstName, LastName) VALUES ('Beth', 'Santos');
INSERT INTO Authors (FirstName, LastName) VALUES ('Shawn', 'Edwards');
INSERT INTO Authors (FirstName, LastName) VALUES ('Kevin', 'Elliott');
INSERT INTO Authors (FirstName, LastName) VALUES ('John', 'Harrison');
INSERT INTO Authors (FirstName, LastName) VALUES ('Jennifer', 'Reed');
INSERT INTO Authors (FirstName, LastName) VALUES ('Shirley', 'Burton');
INSERT INTO Authors (FirstName, LastName) VALUES ('Scott', 'Crawford');
INSERT INTO Authors (FirstName, LastName) VALUES ('Amanda', 'Hall');
INSERT INTO Authors (FirstName, LastName) VALUES ('Joel', 'Graham');
INSERT INTO Authors (FirstName, LastName) VALUES ('Andrew', 'Gibson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Sherry', 'Ramos');
INSERT INTO Authors (FirstName, LastName) VALUES ('Cassandra', 'Moon');
INSERT INTO Authors (FirstName, LastName) VALUES ('Danny', 'Finley');
INSERT INTO Authors (FirstName, LastName) VALUES ('William', 'Fleming');
INSERT INTO Authors (FirstName, LastName) VALUES ('Michael', 'Jackson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Thomas', 'Winters');
INSERT INTO Authors (FirstName, LastName) VALUES ('Stephanie', 'Johnson');
INSERT INTO Authors (FirstName, LastName) VALUES ('Bryan', 'Hart');
INSERT INTO Authors (FirstName, LastName) VALUES ('John', 'Hensley');
INSERT INTO Authors (FirstName, LastName) VALUES ('David', 'Brown');
INSERT INTO Authors (FirstName, LastName) VALUES ('Linda', 'Bell');
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Crime yourself wear', '978-0-18-546252-7', 'Bell-Boyd', 1998, 251, 8, 8, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('My process institution', '978-1-64823-802-4', 'Salazar-Robles', 1997, 743, 6, 6, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Decade push I', '978-0-13-720181-5', 'Cole-Crosby', 2017, 160, 5, 5, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Such cut including', '978-0-201-30194-6', 'Romero LLC', 1989, 393, 6, 6, 5);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Rise apply space', '978-1-314-95489-0', 'Bryan, Holmes and Jones', 2015, 759, 4, 4, 8);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Feel less', '978-1-4260-2544-0', 'Howe and Sons', 1980, 573, 2, 2, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Become painting', '978-0-477-99461-3', 'King Group', 2009, 415, 4, 4, 5);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Blood full speech', '978-1-905314-23-2', 'Green Group', 2019, 470, 9, 9, 9);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Fire manager', '978-1-179-09489-2', 'Pearson LLC', 1988, 607, 4, 4, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Eight', '978-0-7276-3967-7', 'Clark, Johnson and Jimenez', 1999, 769, 2, 2, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Film wide', '978-0-391-61880-0', 'Jensen-Hayes', 1989, 433, 8, 8, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Community property magazine throw', '978-1-276-80564-3', 'Burch, Schneider and Taylor', 1984, 451, 10, 10, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('All a consider', '978-0-88542-628-7', 'Casey, Chaney and Schwartz', 2003, 186, 6, 6, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Read budget less', '978-0-07-840745-1', 'Parker, Yang and Freeman', 2023, 595, 5, 5, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Himself environment', '978-1-126-74181-7', 'Anderson, Peck and Hudson', 1988, 530, 1, 1, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Word not available', '978-1-390-36031-8', 'Ray, Williams and Salazar', 2011, 534, 1, 1, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Fall final', '978-0-666-03933-0', 'Martinez PLC', 2001, 139, 6, 6, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Edge receive Congress', '978-0-12-626498-2', 'Clarke, Moore and Horton', 2015, 537, 4, 4, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Charge leader table', '978-1-57341-240-7', 'Singh, Potter and Jenkins', 1980, 505, 7, 7, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Letter everybody', '978-0-7747-6633-3', 'Johnson-Juarez', 1980, 320, 9, 9, 4);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Fight out whether', '978-1-61593-043-2', 'Mills-Brown', 2003, 213, 8, 8, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Chance environmental', '978-1-59516-287-8', 'Smith, Mcgee and Blankenship', 2016, 589, 8, 8, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Hotel star', '978-0-09-960494-5', 'Allen Group', 1984, 113, 8, 8, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Look surface head', '978-0-573-69142-3', 'Mcdowell, Robertson and Perez', 1994, 360, 2, 2, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Significant it point', '978-0-545-81246-7', 'Chandler-Thompson', 2008, 285, 10, 10, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Shoulder know question', '978-1-159-36069-6', 'Stevens-Moreno', 2002, 315, 6, 6, 8);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Character physical', '978-1-4923-9328-3', 'Harvey Ltd', 1990, 771, 6, 6, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Garden someone kind red', '978-0-629-27159-3', 'Harrell, Bright and Smith', 1999, 754, 4, 4, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Positive direction', '978-0-02-310959-1', 'Anderson-Jones', 1983, 393, 8, 8, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Decade near move', '978-1-4609-0987-4', 'Walsh LLC', 2001, 297, 8, 8, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Operation cover', '978-0-03-361982-0', 'Jones-Moore', 1985, 738, 3, 3, 4);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Every happen raise', '978-1-5246-9865-2', 'York, Roach and Gonzalez', 1991, 169, 9, 9, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Degree spring', '978-1-80276-253-2', 'Reyes and Sons', 1988, 530, 7, 7, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Particular test like', '978-0-06-876675-9', 'White-Martinez', 2003, 311, 9, 9, 3);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Mean speak', '978-1-00-520848-6', 'Sparks Group', 1992, 681, 3, 3, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Partner increase law', '978-1-874367-92-5', 'Chase-Clark', 2022, 153, 8, 8, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Leave time', '978-0-436-37634-4', 'Munoz, Jones and Martin', 2013, 482, 3, 3, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Health phone side', '978-1-66386-283-9', 'Farley, Potter and Moore', 1986, 585, 3, 3, 2);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Stay call through', '978-1-5037-5739-4', 'Mclaughlin PLC', 2009, 532, 3, 3, 4);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('How table', '978-1-05-916438-7', 'Miller, Jackson and Velasquez', 2007, 357, 2, 2, 9);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Although another describe you', '978-0-922609-83-3', 'Lee-Nelson', 1989, 725, 6, 6, 10);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Former family plant', '978-1-945959-04-2', 'Williams, Bentley and Robinson', 2021, 264, 3, 3, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Son involve note', '978-1-09-585558-4', 'Morrison-Frank', 2000, 768, 4, 4, 7);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Subject', '978-0-7719-3966-2', 'Norman-Shelton', 2012, 797, 5, 5, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Process court smile', '978-1-78302-041-6', 'Berry and Sons', 2019, 258, 6, 6, 5);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Garden process', '978-1-253-59652-6', 'Kennedy-Parrish', 2002, 217, 1, 1, 4);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Weight loss so', '978-0-920273-71-5', 'Williams LLC', 1985, 351, 5, 5, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('My hand list', '978-0-400-78154-9', 'Jenkins PLC', 1992, 647, 8, 8, 1);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Leave myself week might', '978-0-523-50530-5', 'Tran, Mitchell and Merritt', 2004, 347, 5, 5, 6);
INSERT INTO Books 
            (Title, ISBN, Publisher, PublicationYear, Pages, TotalCopies, AvailableCopies, CategoryID) 
            VALUES ('Spend enough good how', '978-1-09-985595-5', 'Schroeder, Torres and Johnson', 2009, 380, 4, 4, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (28, 20);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (15, 3);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 9);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (2, 6);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (25, 13);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (17, 5);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (22, 15);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (10, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (21, 14);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (9, 10);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (6, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (22, 6);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (17, 8);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 19);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (5, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (1, 3);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (6, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (8, 6);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (22, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (13, 12);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 10);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 6);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (20, 20);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (29, 20);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (6, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (18, 16);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (24, 4);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (10, 11);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (5, 19);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (20, 2);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (8, 20);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (30, 13);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (15, 12);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (14, 10);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (3, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (3, 6);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 7);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (14, 2);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (15, 13);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (12, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (2, 1);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (12, 13);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (13, 8);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (11, 5);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (1, 4);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (24, 5);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (17, 15);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (16, 8);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (23, 12);
INSERT INTO BookAuthors (BookID, AuthorID) VALUES (2, 15);
INSERT INTO Staff (FirstName, LastName) VALUES ('Steven', 'Morris');
INSERT INTO Staff (FirstName, LastName) VALUES ('Christopher', 'Salinas');
INSERT INTO Staff (FirstName, LastName) VALUES ('Ashley', 'Warren');
INSERT INTO Staff (FirstName, LastName) VALUES ('Darren', 'Garcia');
INSERT INTO Staff (FirstName, LastName) VALUES ('Sophia', 'Knox');
INSERT INTO Staff (FirstName, LastName) VALUES ('Rachel', 'Barajas');
INSERT INTO Staff (FirstName, LastName) VALUES ('Rebecca', 'Smith');
INSERT INTO Staff (FirstName, LastName) VALUES ('Michael', 'Oneill');
INSERT INTO Staff (FirstName, LastName) VALUES ('Carla', 'Bartlett');
INSERT INTO Staff (FirstName, LastName) VALUES ('Anna', 'Long');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Denise', 'Washington', 'patrickhorton@hotmail.com', '797-292-0886x700', '596 Tina Lodge Lowefort, PA 64895', '2024-08-29', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Amanda', 'Hutchinson', 'randallwalker@yahoo.com', '001-804-959-0170x72012', '3229 Higgins Loop West Michaelmouth, NV 78431', '2023-09-05', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Joshua', 'Kramer', 'henry48@duarte-chavez.net', '(769)014-9110', '132 Kara Lights Apt. 075 Maryland, AL 77666', '2024-10-06', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Gregory', 'Miller', 'michael66@lucas.com', '393.377.5520x636', '8667 Chad Ridge Suite 344 Kristenborough, RI 08282', '2023-10-04', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Christopher', 'Mosley', 'hharris@hotmail.com', '(262)068-2417x67486', '1704 Wendy Turnpike New Chris, NC 69920', '2023-06-28', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Angela', 'Miller', 'xbarajas@gmail.com', '(340)900-2968', 'PSC 1446, Box 4448 APO AP 70383', '2024-02-18', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Phillip', 'Reed', 'kevinruiz@rivera.com', '(715)425-2236', '31081 Jones Meadow Apt. 855 Lake Caroline, DC 60392', '2023-07-09', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Matthew', 'Evans', 'yruiz@gmail.com', '935-081-2795x1240', '297 Vanessa Plains Lauraburgh, NV 37375', '2024-05-28', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Tyler', 'Tran', 'ohoffman@gmail.com', '2224042591', '019 Shaw Islands Mcknightchester, SD 45185', '2023-09-05', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('John', 'Holmes', 'michael47@gmail.com', '247-722-8795', '352 Payne Drive Butlertown, NC 50060', '2024-09-13', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Dennis', 'Herman', 'underwoodmegan@nguyen.net', '001-270-202-5288', '51146 Shelly Underpass Apt. 706 Wilsonview, HI 37297', '2024-05-21', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Steven', 'Hart', 'timothy42@yahoo.com', '001-172-923-4030x957', '750 Danielle Wall Port Meganfort, TN 97680', '2023-12-15', 'Standard');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Nicole', 'Mullins', 'amy05@hotmail.com', '321-054-9867x585', '8470 Adams Run Wardberg, OK 59139', '2024-10-18', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Timothy', 'Davis', 'cmichael@hotmail.com', '5645198855', '626 Carson Parkway Apt. 621 East Roger, MO 61082', '2023-10-29', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Cheryl', 'Serrano', 'fordstephanie@mcbride.com', '187.850.8379', '4655 Jackson Streets South Tonya, CT 74224', '2025-02-26', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Christine', 'Roberts', 'samanthawaters@hotmail.com', '001-342-448-1205x9918', '347 Kathleen Centers South Kathleen, NE 49321', '2024-06-08', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('John', 'Johnson', 'vroberts@flores-newman.com', '0635525264', '4873 Sherry Harbors Suite 855 Port David, NH 90940', '2024-04-10', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Ruben', 'Nelson', 'erica21@hotmail.com', '(218)888-8008x6875', '30070 Sweeney Route Suite 935 Thompsonstad, WV 43259', '2025-05-16', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Elizabeth', 'Cox', 'rrobinson@hotmail.com', '+1-496-383-7883x097', '0481 Tanner Road Apt. 224 New Richardborough, IN 43242', '2023-10-03', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Michael', 'Watson', 'elittle@george-miller.com', '038-437-7929x914', '916 Anderson Orchard Port Andrea, HI 81028', '2024-11-08', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Brian', 'Turner', 'dianepatton@gmail.com', '574.041.2190x68215', '59041 Thomas Pike Apt. 983 Johnfurt, AZ 81087', '2024-04-21', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Tiffany', 'Leach', 'carlsondavid@gmail.com', '(665)127-8441', '43173 Jillian Fall Kimberlyhaven, MS 71828', '2023-07-02', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Amber', 'Barrett', 'cooperbrian@yahoo.com', '705-393-7432x17148', 'Unit 6494 Box 6385 DPO AA 77069', '2023-11-12', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Denise', 'Carson', 'ibarrett@duncan.com', '001-560-247-4118', '8557 Holden Mission Suite 813 Whiteside, TX 69646', '2025-06-16', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Allison', 'Hampton', 'molinawilliam@baker.com', '(910)361-1466', '1649 Audrey Trail Apt. 380 Patricktown, AK 15973', '2025-05-19', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Manuel', 'Jones', 'tyrone97@owens.net', '+1-109-084-9151x391', '6803 Wright Divide West Sarah, MT 64669', '2025-03-29', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Tanya', 'Roberts', 'susanpayne@gmail.com', '+1-530-084-7303x460', '07126 Peterson Mount West Amy, MT 49376', '2025-06-08', 'Basic');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Sandra', 'Hicks', 'bradleyamanda@gmail.com', '(596)379-9539x090', '21300 Morgan Shoal Suite 969 Lake Allenshire, OK 75411', '2024-07-07', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('Corey', 'Smith', 'rachelwilliams@garcia.com', '001-380-047-9447x344', '162 Reynolds Islands Suite 536 Johnburgh, WA 82549', '2023-08-26', 'Premium');
INSERT INTO Members 
            (FirstName, LastName, Email, Phone, Address, DateJoined, MembershipType) 
            VALUES ('John', 'Patrick', 'gabriel38@hotmail.com', '+1-466-536-8283x261', '21487 Hughes Expressway Suite 654 West Jonton, DE 08899', '2023-07-17', 'Basic');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 30, 4, '2025-06-16', '2025-06-16', NULL, 3.76, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 26, 3, '2025-06-16', '2025-06-16', NULL, 15.85, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (12, 20, 2, '2025-06-16', '2025-06-16', NULL, 18.63, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (15, 30, 3, '2025-06-16', '2025-06-16', NULL, 1.45, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (1, 9, 5, '2025-06-16', '2025-06-16', NULL, 0.49, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 5, 4, '2025-06-16', '2025-06-16', NULL, 11.16, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (1, 7, 4, '2025-06-16', '2025-06-16', NULL, 15.97, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 17, 2, '2025-06-16', '2025-06-16', NULL, 3.79, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (6, 12, 2, '2025-06-16', '2025-06-16', NULL, 0.78, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 3, 5, '2025-06-16', '2025-06-16', NULL, 4.07, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (8, 5, 1, '2025-06-16', '2025-06-16', NULL, 1.22, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (5, 16, 4, '2025-06-16', '2025-06-16', NULL, 5.92, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (6, 28, 4, '2025-06-16', '2025-06-16', NULL, 8.75, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (6, 8, 3, '2025-06-16', '2025-06-16', NULL, 0.8, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (13, 20, 2, '2025-06-16', '2025-06-16', NULL, 14.19, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 12, 1, '2025-06-16', '2025-06-16', NULL, 4.02, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (13, 30, 2, '2025-06-16', '2025-06-16', NULL, 14.74, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (12, 1, 3, '2025-06-16', '2025-06-16', NULL, 8.46, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (6, 4, 2, '2025-06-16', '2025-06-16', NULL, 5.97, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (7, 4, 3, '2025-06-16', '2025-06-16', NULL, 9.21, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 27, 4, '2025-06-16', '2025-06-16', NULL, 18.55, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 6, 2, '2025-06-16', '2025-06-16', NULL, 1.58, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (1, 11, 1, '2025-06-16', '2025-06-16', NULL, 12.69, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (15, 19, 3, '2025-06-16', '2025-06-16', NULL, 6.33, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (12, 9, 5, '2025-06-16', '2025-06-16', NULL, 3.57, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 12, 4, '2025-06-16', '2025-06-16', NULL, 3.43, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 4, 1, '2025-06-16', '2025-06-16', NULL, 1.56, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (3, 2, 3, '2025-06-16', '2025-06-16', NULL, 13.14, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (6, 2, 5, '2025-06-16', '2025-06-16', NULL, 2.13, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 16, 5, '2025-06-16', '2025-06-16', NULL, 18.02, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (12, 29, 1, '2025-06-16', '2025-06-16', NULL, 18.91, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (8, 9, 5, '2025-06-16', '2025-06-16', NULL, 19.61, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 8, 3, '2025-06-16', '2025-06-16', NULL, 5.68, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (10, 19, 4, '2025-06-16', '2025-06-16', NULL, 7.15, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 15, 4, '2025-06-16', '2025-06-16', NULL, 0.42, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (14, 26, 2, '2025-06-16', '2025-06-16', NULL, 8.26, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 1, 4, '2025-06-16', '2025-06-16', NULL, 17.95, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (2, 28, 3, '2025-06-16', '2025-06-16', NULL, 10.67, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (3, 5, 1, '2025-06-16', '2025-06-16', NULL, 5.73, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (10, 5, 2, '2025-06-16', '2025-06-16', NULL, 11.72, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 14, 5, '2025-06-16', '2025-06-16', NULL, 3.62, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 28, 3, '2025-06-16', '2025-06-16', NULL, 13.86, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (3, 7, 4, '2025-06-16', '2025-06-16', NULL, 17.5, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (4, 1, 2, '2025-06-16', '2025-06-16', NULL, 6.27, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (9, 21, 4, '2025-06-16', '2025-06-16', NULL, 4.4, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (1, 30, 4, '2025-06-16', '2025-06-16', NULL, 12.38, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (9, 3, 4, '2025-06-16', '2025-06-16', NULL, 2.72, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (15, 3, 1, '2025-06-16', '2025-06-16', NULL, 5.62, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (5, 12, 1, '2025-06-16', '2025-06-16', NULL, 5.52, 'Active');
INSERT INTO Transactions 
            (MemberID, BookID, StaffID, TransactionDate, DueDate, ReturnDate, Fine, Status) 
            VALUES (1, 19, 5, '2025-06-16', '2025-06-16', NULL, 2.1, 'Active');