Atlassian interview question

SQL queries for join operations on tables