SQL query:

```
CREATE TABLE  summertraining.student(

studentID VARCHAR( 9 ) NOT NULL ,
Name VARCHAR( 20 ) NOT NULL ,
KSUEmail VARCHAR( 20 ) NOT NULL ,
PhoneNo VARCHAR( 14 ) NOT NULL ,
coordinatorName VARCHAR( 20 ) NULL ,
supervisorName VARCHAR( 20 ) NULL ,
GPA DOUBLE( 4 ) NOT NULL ,
password VARCHAR( 10 ) NOT NULL ,
registerFlag VARCHAR( 7 ) NOT NULL ,
PRIMARY KEY (  studentID )
) ENGINE = INNODB;

```

MySQL said: 

> 
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NOT NULL, `password` VARCHAR(10) NOT NULL, `registerFlag` VARCHAR(7) NOT NULL,' at line 1 strong text
> 
> 
>