请教关于count（*）与like的查询语句
select
(select count(*)
from cpl_OrderItems
where day= '2013-08-01' and businesstypename like 'aaa%') as '1',
(select count(*)
from cpl_OrderItems
where day= '2013-08-02' and businesstypename like 'aaa%') as '2'，
。。。。。。
(select count(*)
from cpl_OrderItems
where day= '2013-08-31' and businesstypename like 'aaa%') as '31'
该语句的查询结果只有一条记录共31个字段，为1-31号businesstypename字段以aaa开头的每天的记录数。这条语句只能查询以aaa开头的记录数，现在我想通过一条语句分别查询aaa开头的每天的记录数和bbb开头的每天的记录数，即查询结果有2条记录，该怎么写？请各位大侠指点！但愿我说明白了。。。。
