Untitled

CREATE TABLE students (
    id INT PRIMARY KEY AUTO_INCREMENT,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    age INT,
    gender VARCHAR(10),
    marks FLOAT
);

INSERT INTO students (first_name, last_name, age, gender, marks) VALUES
    ('John', 'Smith', 20, 'Male', 85.5),
    ('Emily', 'Johnson', 19, 'Female', 78.0),
    ('Michael', 'Williams', 21, 'Male', 92.3),
    ('Sarah', 'Jones', 22, 'Female', 67.8),
    ('David', 'Brown', 20, 'Male', 72.1),
    ('Jessica', 'Davis', 19, 'Female', 88.9),
    ('Daniel', 'Miller', 21, 'Male', 56.7),
    ('Sophia', 'Moore', 20, 'Female', 91.2),
    ('Matthew', 'Anderson', 22, 'Male', 74.5),
    ('Olivia', 'Wilson', 19, 'Female', 82.6),
    ('Andrew', 'Martinez', 20, 'Male', 68.3),
    ('Ava', 'Taylor', 21, 'Female', 95.0),
    ('William', 'Jackson', 22, 'Male', 62.4),
    ('Isabella', 'White', 19, 'Female', 79.8),
    ('James', 'Harris', 20, 'Male', 87.1),
    ('Mia', 'Martin', 21, 'Female', 73.6),
    ('Joseph', 'Thompson', 20, 'Male', 69.7),
    ('Charlotte', 'Garcia', 22, 'Female', 88.3),
    ('Benjamin', 'Martinez', 19, 'Male', 77.2),
    ('Amelia', 'Robinson', 20, 'Female', 90.5),
    ('Henry', 'Clark', 21, 'Male', 65.9),
    ('Ella', 'Hall', 22, 'Female', 81.4),
    ('Alexander', 'Lewis', 19, 'Male', 76.0),
    ('Liam', 'Lee', 20, 'Male', 94.3),
    ('Abigail', 'Walker', 21, 'Female', 71.8),
    ('Sebastian', 'Young', 20, 'Male', 67.2),
    ('Sofia', 'Allen', 22, 'Female', 89.7),
    ('Jackson', 'Wright', 19, 'Male', 84.6),
    ('Scarlett', 'Lopez', 20, 'Female', 76.9),
    ('Aiden', 'King', 21, 'Male', 62.8);