Pergunta de entrevista da empresa SAP

in the coding part I was asked about a SQL question. it is about writing the SQL statement of three joint tables ( I couldn't remember the exact question). I didnt manage to answer that question though.