2018-03-15, 10:40
(2018-03-15, 00:36)archiv Wrote: can someone help me with some querys?
1. find movie plots with specific language (or maybe find a word like "the" in the plot?)
2. find movies with more than 3 genres
3. find movies with video bitrate < 10000
4. find movies with filesize > 10000 mb
1.
sql:SELECT DISTINCT * FROM movielist WHERE Plot LIKE '%the%'
2.
sql:SELECT DISTINCT
movielist.*
FROM
genre
LEFT OUTER JOIN genrelinkmovie ON (genre.idGenre = genrelinkmovie.idGenre)
LEFT OUTER JOIN movielist ON (genrelinkmovie.idMovie = movielist.idMovie)
GROUP BY
movielist.idMovie
HAVING
COUNT(genre.idGenre) > 3
3.
sql:SELECT DISTINCT
movielist.*
FROM
movielist
INNER JOIN MoviesVStreams ON (movielist.idMovie = MoviesVStreams.MovieID)
WHERE
MoviesVStreams.Video_Bitrate < 10000
4. not possible, filesize is not stored to the database