Pergunta de entrevista da empresa Kantar

How would you query this (with a given example database)?