I have the same problem. The year, month and day are not treated as separate columns.

From the comments I had the feeling that is not possible to solve this Kata. But Mr. Google, the Postgre docu and a little simple logic makes it easy... :-)

You're not returning the totals. For example, instead of

product_name | year | month | day | total
-------------+------+-------+-----+------
 milk        | 2019 | 01    | 01  | 200
 milk        | 2019 | 01    |     | 200
 milk        | 2019 |       |     | 200
 milk        |      |       |     | 200

you only return

product_name | year | month | day | total
-------------+------+-------+-----+------
 milk        | 2019 | 01    | 01  | 200

There's a certain language feature which lets you easily generate these.

Is any possibility to format the part of question as the code?

But Postgre 9.6 documentation says: logarithm to base 64 is [edited out]

It doesn't.

Please mark your post as having spoiler content next time. You have the arguments of your second method flipped.

To be more precise, can you poste in git flavored markdown, tell me the language and the specific test you are mentioning?

Ok, why:
test_basicCases - OK
Backstage passes to a TAFKAL80ETC concert, sellIn=15, quality=20
Backstage passes to a TAFKAL80ETC concert -> quality=21

test_edgeCasesOneDay - FAILED
Backstage passes to a TAFKAL80ETC concert, sellIn=11, quality=20
Backstage passes to a TAFKAL80ETC concert -> quality=21

Which condition wasn't fulfiled?

Thanks

Mh, probably no.

Why is test for "Backstage passes to a TAFKAL80ETC concert", sellIn=11, quality=20 failed? The test expects sellIn=10, quality=22 but according to requirements should be there sellIn=10, quality=21. Am I right?