(Solved): Still confused on how to make an SQL statement from the question below: Return the following result ...

Still confused on how to make an SQL statement from the question below: Return the following results. This requires a join. Note: Please use the most modern syntax for doing joins. Do NOT use table aliases. Also take note that this should be done within Microsoft Access.