CREATE TABLE student(
    id INT PRIMARY KEY,
    name VARCHAR(50),
    grade VARCHAR(50),
    marks INT
);

INSERT INTO student
VALUES
(101, "adam", "A", 94),
(102, "bob", "C", 76),
(103, "casey", "B", 82),
(104, "donald", "B", 84),
(105, "emanuel", "E", 38);

-- SELECT*FROM student;

ALTER TABLE student
CHANGE name full_name VARCHAR(50);
-- SELECT*FROM student;

DELETE FROM student 
WHERE marks<80;

-- SELECT*FROM student;

ALTER TABLE student
DROP COLUMN grade;

SELECT*FROM student;