Quantcast

A community for students. Sign up today!

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

No-data

  • 2 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
    • 2 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
    • 2 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
    • 2 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
    • 2 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

Ask a Question
Find more explanations on OpenStudy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.