Cinema for Mary
Uppgift
Swipe to start coding
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema in lexicographical order.
Lösning
9
1
2
3
4
5
6
7
select distinct c.label as cinema
from schedule as s
inner join movie as m on m.id=s.movie_id
inner join genre as g on m.genre_id=g.id
inner join cinema as c on s.cinema_id=c.id
where rating>=7 and (g.label='Fantasy' or g.label='Comedy')
order by cinema
Var allt tydligt?
Tack för dina kommentarer!
Avsnitt 2. Kapitel 1
9
1
Query Result| No query executed yet... |
Fråga AI
Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal
