Infineon Technologies interview question

sql and programming questions involving joins