CREATE TABLE & NOT NULL & AUTO INCREMENT from THENEWBOSTON

Instruction: Create a table with id that auto-increments and columns that is not empty such as username and password. 

CREATE TABLE movie (

id int NOT NULL AUTO_INCREMENT,

username varchar(30) NOT NULL,

password varchar(20) NOT NULL,

PRIMARY KEY(id)

)