title: SQL Pull TY and LY into columns on same row
body: <p>I am not that great with SQL, but here we go.  I have been trying to pull sku counts for <code>TY</code> and <code>LY</code> by week and have them in separate columns, but on the same row depending on the other variable...I.e...</p>
  
  <pre><code>          Week    TY         LY
  ABC        6       30         50
  ABC        5      100         20
  ABC        4       25         25
  </code></pre>
  
  <pre><code>Select
      A.Store,
      B.Week_Num
      COUNT(A.ABC) AS TY,
      COUNT(A.ABC) AS LY
  FROM [Table] O360
  join Date D on D.Week_num = O360.Week_num
  </code></pre>
  
  <p>The code is simplified above.  The challenge is that I am trying to call for the past 3 Saturdays and the Saturday that is 371 Days before each to represent <code>LY</code>....any help would be amazing.</p>