A piece of cake

That's fair - they have been great for practice though! Especially for strings and dates

hi! frankly, my katas are just a product of creativity and imagination :) There are a lot of sites which provide actual interview SQL questions, but here we just have fun

the formatting for this question, especially with how many spaces there are, is a bit finicky. Are actual interview questions this particular?

There is an error in the test cases with this record in employee_works

5 4 2021-02-18 00:00:00 +0000 2024-01-31 00:00:00 +0000

note that the finish_date is set in the future, so the employee hasn't left, but is with us till 2024-01-31

(This comment is published on 2024-01-04)

I had to use finish_date = current_date in order to pass the test cases. Please fix it to mark this employee D as 'Still with us' instead of 'Left'

age in descending order (from youngest to oldest).

this is contradictory, if youngest to oldest -> age in ascending order
if age in descending order -> oldest to youngest

Did you mean DOB?

This was tricky - finally decided to use two CTEs: one for getting the highest transaction amount, and another for the total daily amount before joining the two.

The checker is missing the order by