Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- | ID | ins_name | action | | ID | Name |
- -------------------------- -------------
- | 1 | Аскар | 21 | | 21 | Стикер |
- | 2 | Шыназ | 18 | | 18 | Защита |
- | 3 | Берик | null |
- | 4 | Берик | 18 |
- | ID | Name | | ID | FullName | dept_id |
- --------------------------- ---------------------------
- | 5 | Департамент продаж | | 1 | Mike | 5 |
- select od.name as dept_name, e.Fullname, oac.name, COUNT(oa.id) total
- from dbo.ogpo_dept od
- inner join dbo.employees e on e.dept_id = od.id
- inner join dbo.application oa on oa.dept_id = od.id
- inner join dbo.action oac on oac.id = oa.[action]
- Group By dept_name, e.Fullname, oac.name, oa.[action]
- | 3 | Берик | null |
- | dept_name | Fullname | name | total |
- --------------------------------------------------
- |Департамент продаж | Аскар | Стикер | 591 |
- |Головной офис | Берик | Защита | 54 |
- |Головной офис | Берик | null | 5 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement