Jump to content

Help with MySQL


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

Link to comment
Share on other sites

 Share

×
×
  • Create New...