InfoCepts interview question

Sql question using distinct .