Conduent interview question

SQL Queries on joins, different keywords