请教一句sql

[phalcon]

某月新增用户数 表A 字段mobile 找出字段date like '200309%'的时候出现过的mobile 但是date not like '200309%'的时候没出现过的 总数 Count()

[txlicenhe]

Select count(*) from 表A
where mobile in (select moblie from 表A where date like '200309%')
and mobile not in (select moblie from 表A where date not like '200309%')

[pengdali]

Select count(*) from 表A where date like '200309%' and mobile not in (select moblie from 表A where date not like '200309%')

[xiaogate]

Select count(*) from 表A
where mobile in (select moblie from 表A where date like '200309%')
and mobile not in (select moblie from 表A where date not like '200309%')
我同意这个

[sdhdy]

select count(*) from 表A
where mobile in (select moblie from 表A where date like '200309%')
and mobile not in (select moblie from 表A where date not like '200309%')