Pergunta de entrevista da empresa Sysco LABS

I was asked to normalize a given table and asked some SQL queries to retrieve data