看懂这条sql语句才能说得上自己懂了sql

这条sql语句涉及到的知识点：sum函数表达式，case函数，按天查询，

select p.tag_field,

m.name,

d.title,

p.mac ,

sum(p.behavior=0) pass,

sum(p.behavior=1) focus,

sum(p.behavior=2) interact,

sum(p.behavior=2 and p.sex=1) interact_male,

sum(p.behavior=2 and p.sex=0) interact_female,

sum(case when p.behavior=2 then p.interact_duration else 0 end) interact_time,

sum(case when p.sex=1 and p.behavior=2 then p.interact_duration else 0 end ) interact_time_male,

sum(case when p.sex=0 and p.behavior=2 then p.interact_duration else 0 end ) interact_time_female,

DATE_FORMAT(p.created_date,'%Y%m%d') date

from aiad_passenger_flow as p

left join device as d on d.mac=p.mac

left join media as m on p.tag_field=m.code  

where p.deleted_date is null

GROUP BY p.mac, p.tag_field,date