The candidate is asked to write the outputs for all joins from a given scenario.

• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the mat...read more