cookbook_34.sql

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    enrollment_number VARCHAR(50) NOT NULL
);

INSERT INTO students (name, enrollment_number) VALUES 
('Alice', 'ENR123'),
('Bob', 'ENR124'),
('Charlie', 'ENR125'),
('David', 'ENR123'),
('Edward', 'ENR126'),
('Frank', 'ENR124');