I have the database tables like

1) Movie  (MovieID, Name)

2) Customer (CustomerID, CustomerName)

3) CustomerRating (MovieID, CustomerID, Rating)


Movie and Customer have the many many relationship

and the mapping table is CustomerRating

I need to show a list with Movie Name and Average Rating
How to work with aggregate and how it is possible . Please help regarding this.

Solution

Hi Manish,


don't want to give too much hints, but think of this 

- your aggregate will have 2 sources, movie and customerrating, joined properly (drag them, join should be automatically added)

- you will need to use group by and average functions on the result set, there is a good training video on this.

if you get stuck, show us what you've got and well help you along


Dorine

Solution