Domanda di colloquio di Fractal

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