b. Write a SQL query that calculates the average cost of movies in each genre and displays
it together with the movie genre. Order the movie genre by the average invoice amount
in descending order.
Thanks for reaching out.
Are you referring to a course exam question? Please remember that we are only providing support to content we have created, otherwise we risk giving misleading or incomplete advice, which is something we'd like to avoid, of course.
Looking forward to your answer.