The first bulleted condition doesn't make sense to me. Some examples are needed to clarify. Not really sure how to go about solving this until that's fixed.

It also doesn't make sense that some of the rental_dates occur after 8/1/2005, when supposedly for the context of the problem today is 8/1/2005. How can a customer have rented a video in the future?

why is the email test6@testdomain.com included in the final results if none of the sales are >= 199?

so what happens after the 5th door? 6 opens the doors in the same pattern as the first, and we just loop through the 5 rows until we reach n?

if we have 10 students, then the 10th studen walks through all the doors 10 times again?

the description isn't clear enough on these points.

So I've just googled how to improve query performance, and one thing that keeps coming up is creating an index for the table. don't know how to do that without running two queries though, which I can't do here.

I've always been terrible exercises like these.

I didn't have to order by anything to pass the kata

Me neither.

instruction are not clear AT ALL regarding wins and losses.... extremely frustrating

You should alias some other column.

how're we supposed to orer by location, there's no column for location and it won't let me add one...

I don't even understand what the kata is asking me to do.... no matter how many times a read and re-read the instructions.....

I'm sorry but I just don't understand why there are letters here. I've read the instructions and the wiki article and googled about factorials and can't find any good reason why this would be included.

test cases work find but then you expect letters in the output and my tests fail.

There was no error in my code in terms of math operation. Due to Python's limitations, the division of two very large integers, one a multiple of the other, was causing an error. It took me hours to get over this problem. I hope one day I can solve it much faster.