Creat table for studen

Question

Sid number(4), sname number(25), sub1_marks number(2)

Answer 1

CREATE TABLE `school_db`.`students` (
`sid` INT(4) NOT NULL AUTO_INCREMENT , 
`sname` VARCHAR(25) NOT NULL ,
`sub1_marks` INT(2) NOT NULL , 
PRIMARY KEY (`sid`));

Test on Sqlfiddle:
http://www.sqlfiddle.com/#!9/239940/1