Anglepoint Interview Question

Write a basic join query