Members.sql

-- Insert 20 real records into the Members table
INSERT INTO Members (MemberID, FirstName, LastName, Email, Phone, Address)
VALUES
    (1, 'John', 'Doe', 'john.doe@example.com', '555-1234', '123 Main St, Cityville, USA'),
    (2, 'Jane', 'Smith', 'jane.smith@example.com', '555-5678', '456 Oak St, Townsville, USA'),
    (3, 'Alice', 'Johnson', 'alice.johnson@example.com', '555-9012', '789 Pine St, Villageton, USA'),
    (4, 'Bob', 'Williams', 'bob.williams@example.com', '555-3456', '101 Cedar St, Hamletville, USA'),
    (5, 'Charlie', 'Brown', 'charlie.brown@example.com', '555-7890', '202 Maple St, Boroughburg, USA'),
    (6, 'Eva', 'Martinez', 'eva.martinez@example.com', '555-4321', '303 Elm St, Municipality City, USA'),
    (7, 'David', 'Jones', 'david.jones@example.com', '555-8765', '404 Birch St, Townshipville, USA'),
    (8, 'Sophie', 'Lee', 'sophie.lee@example.com', '555-2109', '505 Walnut St, Settlement City, USA'),
    (9, 'Daniel', 'Kim', 'daniel.kim@example.com', '555-6543', '606 Redwood St, Districtburg, USA'),
    (10, 'Emily', 'Miller', 'emily.miller@example.com', '555-0987', '707 Cedar St, Precinct Town, USA'),
    (11, 'Ryan', 'Nguyen', 'ryan.nguyen@example.com', '555-4321', '808 Oak St, Sectorville, USA'),
    (12, 'Mia', 'Chen', 'mia.chen@example.com', '555-8765', '909 Pine St, Municipality City, USA'),
    (13, 'Oliver', 'Davis', 'oliver.davis@example.com', '555-2109', '1010 Birch St, Boroughburg, USA'),
    (14, 'Ava', 'Garcia', 'ava.garcia@example.com', '555-6543', '1111 Maple St, Hamletville, USA'),
    (15, 'Liam', 'Rodriguez', 'liam.rodriguez@example.com', '555-0987', '1212 Elm St, Townsville, USA'),
    (16, 'Emma', 'Lopez', 'emma.lopez@example.com', '555-4321', '1313 Redwood St, Townshipville, USA'),
    (17, 'Noah', 'Wang', 'noah.wang@example.com', '555-8765', '1414 Walnut St, Districtburg, USA'),
    (18, 'Isabella', 'Martinez', 'isabella.martinez@example.com', '555-2109', '1515 Cedar St, Settlement City, USA'),
    (19, 'James', 'Lee', 'james.lee@example.com', '555-6543', '1616 Oak St, Precinct Town, USA'),
    (20, 'Sophia', 'Smith', 'sophia.smith@example.com', '555-0987', '1717 Pine St, Sectorville, USA');