I need help with code as I working a problem in SQL. The question ask Find the best collaborators. Get the 5 cast members with the highest average scores from the good_collaboration view, and call this score the collaboration_score. This score is the average of the average_movie_score corresponding to each cast member, including actors in cast_member_id1 as well as cast_member_id2. Format all decimals to two places using printf(). Sort your output by collaboration_score in descending order, then by cast_name alphabetically.

Output format (cast_id,cast_name,collaboration_score): 2,Mark Hamil,99.32 1920,Winoa Ryder,88.32

so the inner part is based on a union you have to first union up good_collaboration the cast id1 and score - unioned up with cast id2 and score

The code below provides data but not in the correct order.

def part_gi(self,connection):

############### EDIT SQL STATEMENT ###################################

part_g_i_sql ="select cast_id,cast_name, avg(score) collaboration_score from movies, movie_cast where movies.id=movie_cast.movie_id group by cast_id, cast_name order by collaboration_score desc, cast_name asc limit 5"