How to do simple SQL tasks with MariaDB

In this article I'll look at another interview takehome assignment. This assignment included SQL, python and some logic puzzles. If you read to the end I'll share a fun "trick question" that was also included.