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

At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get our expert's

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this and thousands of other questions.

A community for students.

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

Computer Science
See more answers at brainly.com
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this and thousands of other questions

this is the url: http://www.sqlzoo.net/3.htm
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;
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.

Not the answer you are looking for?

Search for more explanations.

Ask your own question

Other answers:

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

Not the answer you are looking for?

Search for more explanations.

Ask your own question