SQLize | PHPize | SQLtest

-- Customer Table CREATE TABLE customers ( customer_id integer PRIMARY KEY, first_name varchar(100), last_name varchar(100), email varchar(100) ); -- Lets insert data into table -- Customers Table INSERT INTO customers (customer_id, first_name, last_name, email) VALUES (1, 'John', 'Doe', 'johndoe@email.com'), (2, 'Jane', 'Smith', 'janesmith@email.com'), (3, 'Bob', 'Johnson', 'bobjohnson@email.com'), (4, 'Alice', 'Brown', 'alicebrown@email.com'), (5, 'Charlie', 'Davis', 'charliedavis@email.com'), (6, 'Eva', 'Fisher', 'evafisher@email.com'), (7, 'George', 'Harris', 'georgeharris@email.com'), (8, 'Ivy', 'Jones', 'ivyjones@email.com'), (9, 'Kevin', 'Miller', 'kevinmiller@email.com'), (10, 'Lily', 'Nelson', 'lilynelson@email.com'), (11, 'Oliver', 'Patterson', 'oliverpatterson@email.com'), (12, 'Quinn', 'Roberts', 'quinnroberts@email.com'), (13, 'Sophia', 'Thomas', 'sophiathomas@email.com'); select * from customers where last_name = 'Brown';