Pregunta de entrevista de Sysco LABS

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