title: MS Access 2010 SQL Top 3 Sales in Group by
body: <p>I have a table with columns such as year, quarter, team and price. it shows every sale from the team. We have 10 teams in the firm. 
  I want to know for each quarter of each year, which three teams sold the most overall. So where am I stuck? At this point I grouped the total sales per team, per quarter, per year. Still missingt o only get the three best teams with highest sales. I got this so far:</p>
  
  <pre><code>SELECT 
      a1.year,
      a1.quarter,
      a1.team,
      sum(a1.price) as Total
  
  FROM
      tbl_sales a1    
  
  inner JOIN
      tbl_sales a2 
          ON a1.year = a2.year
              and a1.quarter = a2.quarter
              and a1.team = a2.team
              and a1.price = a2.price
       where
             some restrictions here
  GROUP BY
      a1.year,
      a1.quarter,
      a1.team
  </code></pre>
  
  <p>Something tells me I am close, that just a subquery with the top function will help but I just can't figure it out. Any help is very much appreciated :)
  Thanks a lot!</p>