Changes between Initial Version and Version 4 of Ticket #110


Ignore:
Timestamp:
2024-12-04T13:54:05+01:00 (6 weeks ago)
Author:
florian
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #110 – Description

    initial v4  
    2020
    2121{{{
    22 SELECT m.movie_title
    23 FROM movies m
    24 JOIN movie_genre mg ON m.identifier = mg.movie_id
    25 JOIN genre g ON mg.genre_id = g.identifier
    26 WHERE g.genre IN ('scifi', 'comedy')
    27 GROUP BY m.movie_title
    28 HAVING COUNT(DISTINCT g.genre) = 2;
     22SELECT movies.movie_title
     23FROM movies
     24JOIN movie_genre ON movies.identifier = movie_genre.movie_id
     25JOIN genre ON movie_genre.genre_id = genre.identifier
     26WHERE genre.genre IN ('scifi', 'comedy')
     27GROUP BY movies.movie_title
     28HAVING COUNT(DISTINCT genre.genre) = 2;
    2929}}}
    3030