Thanks. I fixed that.
My solution used the difference in days so I didn't notice. (Technically 65 years + 1 day is already older than 65. But I agree, it is better to ask for >= 65 years in the description.)

Great Kata. I wanted to make something similar (as a basic version of my Hierarchy Kata), but now you have been faster :) Looks like most of SQL's basic concepts have already been covered.

By the way, you have an typo in your description: You are describing the "employeees" table, but it's actual name is "employees". Count the 'e's ;)

I had to include that test to get the correct results and pass the test. Maybe it's resolved.

But I have another issue. I find the description a bit confusing. For me, the part "in a given department" sounds like 'spent > $1000 in a SINGLE department' not like 'a total of $1000 in one or more departments', but that doesn't match the expected results.

Hi. Is it intentional that you have two different numbers in the description? You say once 98.00 and then 90.00. The test seems only to work with 90.00. Could you clarify that?

Sorry if the description is confusing. I'm not a native English speaker so I might have used some words in a wrong way. Which parts do you find confusing and how do you think could I improve them? If someone explains me how, I also could add some images to visualize the ideas.

I'm asking for a table with a row for every level 2 department within the company, containing the employee-ID and the name of its manager as well as the total salary and count of all employees older than 65 years within the department and all its subordinate departments (down the hiearchy).
Maybe my example is missleading. It doesn't reflect the expected answer, only the idea of the necessary aggregation.
If you say, this is too much for a single Kata, I could remove the manager part or the salary, reducing it to the pure count of employees. But my goal was to create a challenge.

Ah ok. Thanks for the explanation.