SQL

CREATE TABLE `Student`(

  `GroupID` INTEGER,

  `StudentName` VARCHAR(16),

  `StudentNum` CHAR(8)

);

INSERT

INTO

  `Student`

VALUES(7, '培志', 'A0661010');

INSERT

INTO

  `Student`

VALUES(7, '建凱', 'A0661016');

INSERT

INTO

  `Student`

VALUES(7, '瑋駿', 'A0661018');

INSERT

INTO

  `Student`

VALUES(7, '宏陽', 'A0661036');

INSERT

INTO

  `Student`

VALUES(7, '群皓', 'A0661106');