Tempus AI interview question

The coding challenge was on Codility. It was three questions (two algorithmic and one SQL-based).