DROP DATABASE IF EXISTS students_db;
CREATE DATABASE students_db;
USE students_db; 
 
CREATE TABLE students 
    (
        students_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
        fname VARCHAR(50),
        lname VARCHAR(50),
        major VARCHAR(50),
        age INT,
        credit INT
    );
 
 INSERT INTO students(fname, lname, major, age, credit)
 VALUES
 ('Ellis', 'Min', 'Computer Science', 18, 13),
 ('Tenzin', 'Pema', 'Biology', 22, 317),
 ('Sam', 'Smith', 'Computer Science', 25, 1211),
 ('John', 'Johnson', 'Linguistics', 19, 21),
 ('Dave', 'Smith', 'Chemistry', 23, 54),
 ('Brent', 'Lang', 'Accounting', 22, 11),
 ('Jerimiah', 'Tucker', 'Business', 20, 66),
 ('Lamont', 'Marks', 'Biochemistry', 18, 37),
 ('Diego', 'Miller', 'Physics', 17, 6),
 ('Angelina', 'Randall', 'Art', 26, 41),
 ('Brad', 'Johnson', 'Biology', 22, 13);