CREATE TABLE `student`(
    `id` INT PRIMARY KEY,
    `name` VARCHAR(10),
    `dept` VARCHAR(10),
    `total_credits` INT,
    `admission_date` DATE,
    `status` VARCHAR(10)
);

INSERT INTO `student`
VALUES
(1, "Vincent", "資管", 168, "2014-09-15", "畢業"),
(2, "Dora", "會計", 170, "2014-09-15", "畢業"),
(3, "Mario", "財金", 154, "2013-09-15", "在學"),
(4, "Winnie", "會計", 167, "2014-09-15", "畢業"),
(5, "Anna", "財金", 158, "2012-09-15", "畢業"),
(6, "David", "會計", 122, "2013-09-15", "在學"),
(7, "Linda", "資管", 65, "2012-02-20", "休學");