Posted by Esin Seçil, Jan. 12, 2024, 3:29 a.m.

Top 2 films by category

Hello I have a question about Q64.

I had difficulty with this question. I try to find top 2 films by category. Then I checked the answer. But I didn't understand, why you used MAX(C.name) AS category. What MAX() stands for? Another subject is; Why payment table is our main table? I start to query with film table. Because the question starts with top 2 films. So, I think that I use I main table must be film. Can you help me, I will be so happy.

 

Thank you

Answer

Answers


Comment
SQLPad user: Leon Wei

- Leon (934)

Jan. 12, 2024, 10:23 a.m.