Shepper Interview Question

A technical SQL question based on their database