SELECT首次下单日期    ,COUNT(DISTINCTbussinessid)AS下单商家数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="1"THENbussinessidEND)AS第2日下单数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="2"THENbussinessidEND)AS第3日下单数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="6"THENbussinessidEND)AS第7日下单数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="14"THENbussinessidEND)A

SELECT首次下单日期    ,COUNT(DISTINCTbussinessid)AS下单商家数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="1"THENbussinessidEND)AS第2日下单数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="2"THENbussinessidEND)AS第3日下单数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="6"THENbussinessidEND)AS第7日下单数    ,COUNT(DISTINCTCASEWHEN首单间隔天数="14"THENbussinessidEND)A