select 日期, (select count(*) from {表A} as b a.日期 = b.日期1) as 日期1, (select count(*) from {表A} as b a.日期 = b.日期2) as 日期2 from {表A} as a