Collabera Interview Question

For the SQL they asked how to join the data from the 2 tables?