I thought I was looking at my solution. So close!

Works for any number of dimensions.

I like this one, the intent is very clear. Good job.

This should work for any number of dimensions.

The description wasn't very clear for me. So I went with a solution that doesn't even use the subjects table at all.

I guess this shouldn't pass the tests:

select * from (
  select student_id, student_name
  from students natural join marks
  group by student_id, student_name
  order by sum(mark_rate) desc
  fetch first 1 row with ties
) top
order by student_id desc

(I am just ranking the students by the sum of their marks.)

Thank you for all the SQL katas. :)

The schema of the film table in the kata description is incomplete. The columns are:

• film_id
• title
• description
• release_year
• language_id
• rental_duration
• rental_rate
• length
• replacement_cost
• rating
• last_update
• special_features
• fulltext

I wasn't understanding why my natural join didn't work.