I have a table with a structure like this:
I need to create a report like this:
Week # 2015 Amount 2014 Amount
1 5,000 4,750
2 7,500 6,000
through week 52
What is the proper and most efficient way to structure a query to produce these results?