Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- manager | aon
- user1 | 7972207
- user2 | 8581041
- user3 | 3642345
- user1 | 8089142
- user2 | 7972207
- user2 | 0297188
- user1 | 8089142
- user3 | 3642345
- user4 | 3642345
- user1 2
- user2 2
- user3 1
- user4 0
- SELECT `manager`, COUNT(*) AS `calls`
- FROM (SELECT * FROM `calls` GROUP BY `manager`, `aon`) c
- GROUP BY `manager`
- SELECT distinct(calls) FROM calls;
- select t1.manager, count(t2.aon) as cnt
- from (
- -- этот подзапрос нужен, чтобы не потерять менеджеров без звонков
- select distinct(manager) as manager
- from Table
- ) t1
- left join (
- -- если у двух разных менеджеров есть один и тот же номер звонка
- -- то он учтется только у менеджера, который выше по алфавиту
- select min(manager) as manager, aon
- from Table
- group by aon
- ) t2 on t1.manager = t2.manager
- group by t1.manager
- order by t1.manager
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement