Jump to content

Help with MySQL


  • Please log in to reply
No replies to this topic

#1
raymondu999

raymondu999

    InsanelyMac Protégé

  • Members
  • Pip
  • 31 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

Attached Files







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

© 2014 InsanelyMac  |   News  |   Forum  |   Downloads  |   OSx86 Wiki  |   Mac Netbook  |   PHP hosting by CatN  |   Designed by Ed Gain  |   Logo by irfan  |   Privacy Policy