Fluidonomics interview question

Testing types and technics, Simple sql queries on join and union.