Oppgave 4 – Har ingen anelse

a)
SELECT * FROM movie

ELLER

SELECT * FROM movie, casting, actor
WHERE movie.id = casting.movieid AND casting.actorid = actor.id

b)
SELECT title, movie.id, yr FROM movie
ELLER

SELECT title, movie.id, yr FROM movie, casting, actor
WHERE movie.id = casting.movieid AND casting.actorid = actor.id
ELLER
SELECT DISTINCT title, movie.id, yr FROM movie, casting, actor
WHERE movie.id = casting.movieid AND casting.actorid = actor.id

c)	SELECT id, title, yr
FROM movie
WHERE yr = '1962'

d)	SELECT title, yr
FROM movie
WHERE title = 'citizen kane'


e)	SELECT id, title, yr
FROM movie
WHERE title LIKE '%star trek%'
ORDER BY yr DESC
f)	SELECT * FROM movie, casting, actor WHERE movie.id = casting.movieid AND casting.actorid = actor.id AND title IN('another year','arthur') // Fant ut at IN er mer effektivt enn mange AND queries.
g)	SELECT movie.id, title, yr, actor.id, actor.name FROM movie, casting, actor WHERE movie.id = casting.movieid AND casting.actorid = actor.id AND title IN('another year','arthur')
h)	SELECT * FROM actor
i)	SELECT name FROM actor
WHERE id NOT IN (SELECT actorid FROM casting)
j)	SELECT * FROM movie, casting
WHERE movie.id = casting.movieid AND casting.actorid IS NULL
Alle filmene har skuespillere håper jeg. Ellers er svaret feil, vanskelig å verifisere.
k)	SELECT * FROM movie, casting
WHERE movie.id = casting.movieid AND casting.actorid IS NULL AND movie.yr = '2011'
l)	SELECT id, name FROM actor
WHERE name = 'Harrison Ford'
m)	SELECT id, name FROM actor
WHERE name LIKE '%ford'
n)	SELECT id, name FROM actor
WHERE name LIKE '% ford' 	//’%(mellomrom)ford’
o)	Han er registrert to ganger
p)	SELECT casting.movieid, actor.name FROM casting, actor
WHERE casting.actorid = actor.id AND actor.name = 'Harrison Ford'
q)	SELECT movie.title, actor.name FROM movie, casting, actor
WHERE movie.id = casting.movieid AND casting.actorid = actor.id AND actor.name = 'Harrison Ford'