Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

No-data

  • 4 years ago

I'm having problems with the problem 4a. I would appreciate some guidance. This is what I have until now.

  • This Question is Closed
  1. No-data
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    this is the url: http://www.sqlzoo.net/3.htm

  2. No-data
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    and this is what I have: SELECT m.yr FROM movie m INNER JOIN actor a INNER JOIN casting c ON m.id = c.movieid AND a.id = c.actorid WHERE a.name = 'John Travolta' ORDER BY yr;

  3. No-data
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I'm getting a list with the years Travolta made a movie. I know I need a GROUP BY and a COUNT. But the don't work when I put them into the SELECT.

  4. waybeyond
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    This should yield your results: select m.yr, count(m.id) as NumMovies from movie m inner join casting c on c.movieid = m.id inner join actor a on a.id = c.actorid where a.name = 'John Travolta' group by m.yr order by NumMovies desc

  5. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy