Pergunta de entrevista da empresa Rakuten

Interview 1: Live coding 1: You get some csv text. You need to parse it and then generate a query to calculate something. This is a medium hard SQL question.