Untitled
plain_text
a month ago
1.6 kB
1
Indexable
Never
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);