Top 2 films by category

Hi Esin Seçil,

Thank you for your insightful questions. Here are my answers, and please feel free to reach out if you have any more queries.

1. Using MAX(C.name) is a common technique to fetch the name without needing to group. Since all entries share the same value, other aggregation functions like MIN would also work and give you the same result. We often use this trick and have seen many others use it as well. Since the name and the ID have a one-to-one correspondence, this method works effectively.

2. You're absolutely right; there are various ways to tackle this problem, and please feel free to start from any table you prefer. For our official solution, we start with the Payment table. This approach allows us to omit movies that aren't generating revenue so we can improve the query effieiency, as the top two films are defined by their revenue.

Hope this helps,

Leon