Jump to content
  • Announcements

    • Allan

      Forum Rules   04/13/2018

      Hello folks! As some things are being fixed, we'll keep you updated. Per hour the Forum Rules don't have a dedicated "Tab", so here is the place that we have our Rules back. New Users Lounge > [READ] - InsanelyMac Forum Rules - The InsanelyMac Staff Team. 

1 post in this topic

Recommended Posts

I have these tables (sql is attached so that you can see how the db is structured).

 

Now, I have to take, for each celebrity, the movies that he/she starred in, the year of release of the movie, the "average rating" as from the query above, and the amount of awards. So for example, an artist Mr. Bob Smith might have the following returned for him: (attached)

 

I'm really stumped on this any help is appreciated

Create_Table.sql.zip

post-323670-1238329456_thumb.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Recently Browsing   0 members

    No registered users viewing this page.

×