Question

how to create a SQL table

Answer 1

Movie table


CREATE TABLE "MOVIE" (
"Id" int(11) NOT NULL  DEFAULTS "0",
"name" VARCHAR (100)  DEFAULTNULL
"year" int(11) DEFAULT NULL
"rank" float DEFAULT  NULL
PRIMARY KEY "Id"


Considering the above table. How many movies does the dateset have for the year ?  Write a ur query below.