Infor interview question

a sql question that was wrong based on the table they described