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.

Comments in the code lead to errors in the attempt tests

A lot of posted solutions should not be valid because tests do not check for a proper window function!

This problem contains the most retarded tests I have even seen. They should be re-written/fixed of this assignment should not be on this site.

The instructions don't specify if total_count and total_amount should be all payments, or all payments made to either Jon or Mike

As the test database currently only has those two entries in staff, the results are the same, and both versions will pass the tests. But the corresponding queries are different, so it seems like an oversight.

why have all this latin stuff, why not use something more like, you know, the EXAMPLE???
data unecessarily complicated for absolutely no reason besides pretentiousness

wite -> wRite

I failed a test requiring no "PARTITION" clauses because I has a commented-out line with "PARTITION" in it. Maybe the tests should ignore commented-out lines? I realize that it might be bad form to leave tons of comments, so I don't feel too strongly about this.

You need to check 27 and 60 which are actor_ids of Julia Mcqueen && Henry Berry. Disabling these words doesnt makes sense by (select concat(first_name,' ', last_name) as first_actor
from actor where actor_id = 27)