raymondu999 Posted March 29, 2009 Share Posted March 29, 2009 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 Link to comment Share on other sites More sharing options...
Recommended Posts