Pergunta de entrevista da empresa MSCI

They give me a table and told me to normalise it. Also after normalisation, they told me to write a basic SQL query to fetch data from multiple tables.