Pasted

/* Return all of the unique years in the movie table  */ 
SELECT *  FROM movies
ORDER BY YEAR ASC;
 
 
/* Return all of the unique years in the movies table sorted from oldest to newest. */ 
SELECT * FROM movies 
WHERE genre = 'drama'; 
 
/* Return all movies that are dramas. */ 
SELECT * FROM movies
WHERE name LIKE '%bride%';
 
/* retunere kun film fra year 2000 til 2015, de bliver s sorteret i descending order.   */ 
SELECT * FROM movies
WHERE YEAR
BETWEEN 2000 AND 2015
ORDER BY YEAR DESC;
 
/*retunere movies som er udgivet i 1995 eller har en imdb rating p 9.0  */ 
 
SELECT * FROM movies
WHERE YEAR = 1995 
OR 
imdb_rating = 9; 
 
/* retunere MAX 3 movies fra movies hvor at rating = 3    */ 
SELECT * FROM movies 
WHERE imdb_rating = 7 
LIMIT 3; 
 
/*retunere movies hvor at rating er > 6
hvor at genre er comedy, er lavet efter year 1995
Der retuneres max 10 */ 
 
SELECT *  FROM movies
WHERE imdb_rating  > 6 
AND
genre = 'comedy'
AND
YEAR > 1995
ORDER BY imdb_rating DESC
LIMIT 10; 
 
/* retunere alle film som har prcis navnet "Cast Away"    */ 
SELECT * FROM movies
WHERE name = 'Cast Away'; 
 
 
/* retunere alle film som IKKE har rating 7   */ 
SELECT * FROM movies 
WHERE imdb_rating  != 7; 
 
 
/* Retunere alle horror movies med en drligere rating end 6 */ 
SELECT * FROM  movies 
WHERE genre = 'horror'
AND 
imdb_rating < 6; 
 
/*retunere 10 movies hvor rating er 8 og sorteret med genre   */
SELECT * FROM movies 
WHERE imdb_rating = 8
ORDER BY genre  ASC
LIMIT 10; 
 
 
 
 
/* retunere alle mobies hvor "king" er indeholdt  */ 
SELECT * FROM movies 
WHERE name LIKE '%King%'; 
 
/* retunere alle movies hvor at Out er det sidste ord.  */ 
SELECT * FROM movies 
WHERE name LIKE '%Out';
 
/*Return all the movies with name that begin with the word "The" sorted by imdb rating from highest to lowest  */ 
SELECT * FROM movies
WHERE name LIKE 'The%'
ORDER BY imdb_rating DESC;
 
/* Return all of the movies   */ 
SELECT * FROM movies; 
 
/* Return the name and id of each movie with an id greater than 125  */ 
SELECT DISTINCT name  FROM movies 
WHERE id > 125;
 
/*Return all movies names that begin with 'X-Men' */
SELECT * FROM movies 
WHERE name LIKE'X-Men%'; 
 
/*Return the first 10 movies sorted in reverse alphabetical order  */ 
SELECT * FROM movies
WHERE id  < 11
ORDER BY name DESC; 
 
/*Return the id, name and genre of all movies that are romances   */ 
SELECT DISTINCT id, name, genre FROM movies 
WHERE genre = 'romance';
 
/*Return all of the Twilight movies in order from the year they were released from oldest to newest */ 
SELECT * FROM movies 
WHERE name LIKE '%Twilight%'
ORDER BY YEAR ASC;
 
/*Return all of the movies that were released in 2012 that are comedies  */ 
SELECT * FROM movies 
WHERE YEAR = 2012
AND
genre  = 'comedy';