Question d’entretien chez Fractal

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