Lets see what you have tried.
SELECT COUNT(movie.id),movie.yr FROM movie JOIN actor ON actor.id=movie.id JOIN casting ON movie.id=casting.movieid WHERE actor.name='John Travolta'
SELECT movie.title, actor.name FROM movie JOIN casting ON movie.id=casting.movieid JOIN actor ON actor.id=movie.id WHERE movie.director='Julie Andrews' AND casting.ord=1
SELECT movie.title,casting.ord FROM movie JOIN casting ON movie.id=casting.movieid WHERE movie.yr=1978 ORDER BY casting.ord ASC
thank you in advance for correcting my mistakes.
i think that i have wrongly understood the concepts of JOIN despite my several trials, can you please help
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.