Advarra interview question

Oops, project related questions, sql joins