BasicQueries

CREATE TABLE Directors (
Id INT IDENTITY NOT NULL PRIMARY KEY,
DirectorName VARCHAR(100) NOT NULL,
Notes VARCHAR(MAX)
)

CREATE TABLE Gernes (
Id INT NOT NULL PRIMARY KEY,
GerneName VARCHAR(MAX),
Notes VARCHAR(MAX)
)

CREATE TABLE Categories (
Id INT NOT NULL PRIMARY KEY,
CategoryName VARCHAR(MAX),
Notes VARCHAR(MAX)
)


CREATE TABLE Movies (
MovieId INT NOT NULL PRIMARY KEY,
Title VARCHAR(MAX) NOT NULL,
DirectorId INT NOT NULL,
CopyrightYear DATE,
LENGTH INT,
GerneId INT NOT NULL,
CategoryId INT  NOT NULL,
Rating INT,
Notes VARCHAR(MAX)
)


INSERT INTO Directors
VALUES ('Christopher Nolan','Excellent!'),('Martin Scorseze','Very very good!'),('Steven Spielberg','WOW!Symply WOW'),('Alfred Hitchcock','Marvalous!'),('Jerry Bruckheimer','Not so bad at all')


INSERT INTO Gernes
VALUES (1,'Horror','Scary'), (2,'Action','energy'), (3,'Fantasy','Adventure'), (4,'Sci-Fi','Scinece'), (5,'Comedy','Laughter')

INSERT INTO Categories
VALUES (1,'Excellent','More than 1 oscar'), (2,'Good','One oscar'), (3,'Not Bad','No oscars, but good actors'), (4,'Meh','Bad actors and bad play'), (5,'Not good','Bad actors + Bad director')

INSERT INTO Movies
VALUES (1,'Jurassic Park',3,'1999-09-12',120,2,1,100,'Good effects and good story'),(2,'Prometeus',1,'2015-10-12',129,3,2,70,'So many unanswered questions'),(3,'Captain America: Civil War',5,'2016-05-17',130,4,2,90,'Favourite movie eveeer'),(4,'The Hangover',2,'2010-03-18',115,5,3,17,'not so impressed'),(5,'Psycho',4,'1962-02-20',119,1,1,50,'Not so bad movie')