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%')
where mobile in (select moblie from 表A where date like '200309%')
and mobile not in (select moblie from 表A where date not like '200309%')
where mobile in (select moblie from 表A where date like '200309%')
and mobile not in (select moblie from 表A where date not like '200309%')
我同意这个
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%')