Fractal Interview Question

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