Solirius interview question

simple SQL questions around joins and queries.