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