Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
Great kata for understanding recursive query!
just cheked,
really there are identical category name but different id.
It's look very strange as it is expected that category name should be unique as well as id.
Solution with JOIN LATERAL is not working correctly (it returns for some categories 4 most viewed posts intead of 2). At the same time solution with ROW_NUMBER returns right result. Please try two solutions and you will see...
Solution with JOIN LATERAL is not working correctly (it returns for some categories 4 most viewed posts intead of 2). At the same time solution with ROW_NUMBER returns right result.
Please try two solutions and you will see...
This comment is hidden because it contains spoiler information about the solution
I liked it. Task on some seconds
easy task