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.
Did you check whether they have identical category_id on those "4 most viewed post"?
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
Nice kata
works! Thanks!
This kata was great but when I tried to calculate perimeter as l + l + w + w, it did not work.
I liked it. Task on some seconds
easy task