Quantcast

Got Homework?

Connect with other students for help. It's a free community.

  • across
    MIT Grad Student
    Online now
  • laura*
    Helped 1,000 students
    Online now
  • Hero
    College Math Guru
    Online now

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

No-data Group Title

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

  • 2 years ago
  • 2 years ago

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

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

    • 2 years ago
  2. No-data Group Title
    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;

    • 2 years ago
  3. No-data Group Title
    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.

    • 2 years ago
  4. waybeyond Group Title
    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

    • 2 years ago
    • Attachments:

See more questions >>>

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.