author left this kata?

fixed, thanks :)

Hello!

you have write rimary instead of primary in task description)

Good kata, thanks)

This is motivating task for learning)

But my solution above with partition by title passed some random test)

Sorry, missed it. Yes, indeed the issue is with your query because there is a possibility of the same title for multiple ids. In real life this also can happen, closing an issue. cheera!

I found a reason

in the fact of having the same titles

that one unique ID can have.

Did the author leave this kata?

Or was my question confusing?

Hello!

Can you please review kata

my solution pass test cases for some attempt

but also this solution as i check latter fit for only 6 cases and 2 was failed

I mentioned also count(*) "c" and category table have "c" alias in my success attempt

Hello! Can you explain task statement:

"The sales data may include multiple sales with the same timestamp. Make sure your query correctly handles this situation."

"same timestamp" referer to date + time then sales refer to record of sale attributes (tuple or record)
Is it about duplicates?

I spent some etra time to find my mistake, maybe my comment be helpful

Note that lexicographical sort and numerical sort is different things
This related to part where you need to define student course by highest score =)