What does a RIGHT JOIN ensure?
RIGHT JOIN
that all records from the rightmost table are represented in the result, even if there are no corresponding records in the left table
that only records from the rightmost table will be displayed
that records from the rightmost table will be displayed only if the records have a corresponding value in the leftmost table
that no records from the rightmost table are displayed if the records dont have corresponding records in the left table