Assuming the factSale table is our primary table, why was the RIGHT join the correct choice to get a

complete list of products and sales, including products with no sales?

A right join was not the correct choice.

A right join returns all products, which could have been achieved with an inner join.

A right join returns all rows from the joined table, regardless of whether they have sales.

Right joins return all rows in both tables, regardless of what matches exist.