This query provides Year to date numbers for both Price and Square Feet of the current year and the previous year to date. Is there anyway I can add extract or date_trunc or some other function, which would provide me with the weeks from 1 through 7 (week 7th of 2017 ended on 02/19/2017) of the c...