it was really difficult and I couldn't solve it without help from outside.... I learned new things. many thanks to the author
I failed a test requiring no "PARTITION" clauses because I has a commented-out line with "PARTITION" in it. Maybe the tests should ignore commented-out lines? I realize that it might be bad form to leave tons of comments, so I don't feel too strongly about this.
I spent 10 minutes (cuz long query times) trying to figure out how to join tables to get results for only Jon and Mike, just to find out there is noone else... -___-
if i showed you my code (that worked), you might think i am actually mental :D took me a few hours and feels like very cpu intensive and a lot of potentially unnecessary logic..but it worked in the end
'Test' button fails the query on expected results. 'Attempt' button accepts the same query as being correct.
Is it somewhat more performant than "default" (simple join) solution?
Like, it is applies limit only on the first subquery, so there is no need to watch the whole customer's table.
This comment is hidden because it contains spoiler information about the solution
Good way to learn FILTER
I think it's related to switching the order of the function's input dates
You need to check 27 and 60 which are actor_ids of Julia Mcqueen && Henry Berry. Disabling these words doesnt makes sense by (select concat(first_name,' ', last_name) as first_actor
from actor where actor_id = 27)
doesn't support SQLite
I have written multiple functions that work on pgadmin, but don't work on this kata. The only difference I see in expected results are
Expected results: ... :n=>95, :m=>0
Actual results: ... :n=>95, :m=>95
What does this mean?
Thanks for the Kata!
Is it possible to get somewhere a look on the dataset? ( Not just running it in test mode).
It could be very helpfull