SQL Query Problem

SELECT i.item_Description, sum(f.item_count) FROM tbl_Bakery_Order_Facts f INNER JOIN tbl_Items i ON f.Item_ID = i.Item_ID INNER JOIN tbl_Departments d ON f.Department_ID = d.Department_ID INNER JOIN tbl_Promos p ON f.Promo_Code = p.Promo_Code where d.dept_description = 'Speciality Pastries'

Voici comment avoir les 2 articles les plus fréquents pour chaque département
Il suffit d'ajouter une restriction sur le(s) département(s) souhaité(s)

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
select * from     
  (select B.Department_ID
        , D.Dept_Description
        , B.Item_ID
        , I.Item_Description
        , count(*)
        , dense_rank() 
          over(partition by B.Department_ID, D.Dept_Description
               order by count(*) desc
              ) as RK
   from tbl_Bakery_Order_Facts B
   inner join tbl_Departments D
      on D.departement_id=B.departement_id
   inner join tbl_Items I
      on I.Item_ID=B.Item_ID
   group by D.departement_id
          , D.dept_Description
          , B.Item_ID
          , I.Item_Description
   order by B.Departement_ID
          , count(*) desc
  ) as sub
where sub.RK < 3

J'ai pu commettre quelques fautes dans les noms lors de la recopie