I'm beginner ,
i work with SQL Server 2008 R2
i have 3 tables (data base of film library)
customers and film genres,
customers and actors,
customers and directors,
The query that i need to implement is
"display favorite actor, director , favorite film type(genre)
where favorite means that film was rented out the greatest number of times"
a tables that were mentioned above had customer's Id ,
customer name (for tables with actors)
actor id , actor name ,
times film with this specific actor was taken by customer,
the same i have in other tables (favorite film genre, favorite director)
problem is that i have customers which don't have maximum value or have few values with same number i.e. MAX() don't work here .
please if any one can help ?
here is the code for favorite director table :
...
Go to the complete details ...