Anglepoint interview question

Write a basic join query