Pergunta de entrevista da empresa Fractal

How would you create a year-to-date column for sales using SQL joins?