question

mollylolly123 avatar image
mollylolly123 asked

Please help!! Beginner struggling

List the top actors according to the number of movies they appear in. Your answer should include the name of the actor and a count of the movies and should sort the list in descending order by count. Choose a movie count that will get you a list of at least 10 and no more than 20 actors and use a HAVING CLAUSE to limit the results to actors with at least that many movies.

sql query
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

We can certainly help but we know nothing about the table or tables you're working worth,. Can you post the CREATE TABLE statement for each table you need to work with? Otherwise, we're just guessing.

1 Like 1 ·

What have you tried thus far? If you can post code we can help point you in the right direction.

0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.