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.
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.Too easy for 5q imho
The description of the kata is correct. There are no cases in the tests where three posts of the same category are included. In such a case post id is used as a tiebreaker. That being said categories can have only one or no posts at all. When there are no posts you still need to return a row with category_id and category values.
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
Never used it, but this one was a good intro and I definitely had to read the docs and other resources to solve it.
+1 I am grateful to have been able to get through a solution based on various resources, but I can't say that I fully grasp the LATERAL functionality. Exciting to continue pursuing this concept!
and division of negative integers.
The tests seem to work correctly now.
I'm not aware of any issue like this specific to Codewars.
n
andm
were results ofweekdays
with different orders of arguments. I've changed the names toweekdays_date1_date2
andweekdays_date2_date1
.Fixed.
count + lag(count,1) over (partition by date order by date)
code issue != kata issue, closing!
A lot of posted solutions should not be valid because tests do not check for a proper window function!
My solution works perfectly on my local machine with PostgreSQL, but this kata throws this at me:
Does anybody know what do these
n
andm
mean?Loading more items...