Results [..] should be ordered by product_id (asc) and then by the sequence of the letters as they appear in the features string for each product.

Is the second criterion actually enforced ? Or even enforceable ? My own solution does not explicitely take care of it, I'm not sure whether it's because PostgresSQL produces a stable sort as an implementation detail (since the SQL standard does not make such a guarantee) or whether it's a consequence of using regexp_split_to_table()

I am currently working on this kata on sunday, and I’m encountering some issues with the tests. The "results: expected" field appears blank in the sample test suite, as well as in the random tests within the full test suite. For the edge case test, there are two valid entries for sale_date with dates "2024-10-19" and "2024-10-20." However, in the sample tests, sale_date values fall between "2024-10-21" and "2024-10-30," and in the random tests, they range from "2024-10-21" to "2024-11-04."
(Edit: I tried it again with the exact same solution on the following day and it passed with flying colours, so there is something wrong with the tests on sunday)

The task is great! I would add a little note that a student can take the same course only once.

The term "previous week" refers to the time period that begins on the Monday immediately preceding the current week and ends on the following Sunday. This time period is considered to be the last complete week that has passed.

A week here is defined to start on Monday and end on Sunday. it has to be complete, i.e. 7 days. the current day of the week is irrelevant to this definition: all days share the same "last week"

My solution relies on the ISO 8601 week number and would return wrong results if:

• the tests included sales made in previous years during the week that shared the same week number as the last week
• the current week is the week number 1 of the year, as I decrement by 1 to find the previous one, which would give 0, an invalid week number. (perhaps that one is impossible to catch)

Could you clealry explain that only developer_id=1 must be checked,
or to drop records with develper_id = 2 from second random test?

I hadn't found this in the description,
so could not understand why my final test adds two extra records,
then I made ugly cheat hack to open solutions,
only to see - they all check developer_id=1 explicitly...

the total rentalal could be decimals , should we round it to nearest integer to determine if it is a prime number?

Yeah same here but wtv

it should be mentionned that the sequence always starts from 1

This comment has been deleted.

agree. this looks like a bug. I'm getting the same error

Suggest us, how we can achiev this for those assignment has been left. if know that check this url https://myassignmenthelp.expert/do-my-homework.html

Displays the name and ID (in the format of name (id) of the winning runner in that race if the current runner's position is not 1

the desired output is the following:
...

| runner_name  | run_id | position | race_id | win/second        |
...
| John Runner  |      4 |        3 |       2 | Second Runner (2) |

Why is it "Second Runner" for position = 3?..

In the random tests, there are duplicate features in the special_features column; features array such as {"Deleted Scenes","Deleted Scenes",Trailers} are apparently expected to be rejected.

the description only says:

returns only the films that have only "Trailers" and "Deleted Scenes" as their special features

which does not make it obvious how duplicate entries should be handled - i would expect duplicate entries to be idempotent. Perhaps this should be clarified ?