Movie for Phoebe
Tehtävä
Swipe to start coding
Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!
Ratkaisu
9
1
2
3
4
5
6
select movie.label, rating, director.full_name
from movie
inner join director on director.id=movie.director_id
where director.full_name in ('Gerard Krawczyk', 'Frank Darabont', 'Christopher Nolan')
order by rating desc
limit 1
Oliko kaikki selvää?
Kiitos palautteestasi!
Osio 1. Luku 5
9
1
Query Result| No query executed yet... |
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
