queries sql

/*Езици без повторения, не на английски*/
select title, language
from movies
inner join language on id = language.Movie_id
where language != 'English';



/*Списък на всички езици без английски на филми със субтитри*/
select language.Language, language.IsSubtitles, boxoffice.Movie_id, movies.Title
from language
inner join boxoffice on boxoffice.Movie_id = language.Movie_id
inner join movies on movies.Id = boxoffice.Movie_id
where language != 'English';

/*Кои режисьори са работили над Toy Story 2,3,4 подредени по години*/
select directors.Director_name, movies.Year, Movie_id, movies.Title
from directors
right join MoviesDirectedBy on directors.Id = MoviesDirectedBy.Director_id
right join movies on movies.Id = MoviesDirectedBy.Movie_id
WHERE movies.Title LIKE 'Toy Story%'
ORDER BY movies.Year ASC;

select movies.Year, movies.Title
from directors
left join MoviesDirectedBy on directors.Id = MoviesDirectedBy.Director_id
inner join movies on movies.Id = Movie_id