A community for students.
Here's the question you clicked on:
 0 viewing
Nodata
 3 years ago
I'm having problems with the problem 4a. I would appreciate some guidance. This is what I have until now.
Nodata
 3 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

Nodata
 3 years ago
Best ResponseYou've already chosen the best response.0this is the url: http://www.sqlzoo.net/3.htm

Nodata
 3 years ago
Best ResponseYou've already chosen the best response.0and 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;

Nodata
 3 years ago
Best ResponseYou've already chosen the best response.0I'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.

waybeyond
 3 years ago
Best ResponseYou've already chosen the best response.0This 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
Ask your own question
Sign UpFind 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
 Engagement 19 Mad Hatter
 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.