下面需要查询显示出次数最多的项目，不知道问题在哪里？

"本周<font color='blue'>进行了" + sql("jiaoxei", "select count(检查项目) 检查次数合计 from dbo.班级考核 where convert(varchar(10),检查时间,23) between '" + dateinweek(today(), 1) + "' and '" + today() + "'", 1, 1) + "次评价，<font color='blue'>" + "这些评价涉及了<font color='blue'>" + sql("jiaoxei", "select distinct 检查项目 from dbo.班级考核 where convert(varchar(10),检查时间,23) between'" + dateinweek(today(), 1) + "' and '" + today() + "'", 1, 1) + "。评价次数最多的指标为【<font color='blue'>" + sql("jiaoxei," select top 1 * from (select top 1 * from (select 检查项目,count(*) as 次数 from dbo.班级考核 

 where convert(varchar(10),检查时间,23) between '" + dateinweek(today(), 1) + "' and '" + today() + "' group by 检查项目)t order by 次数 desc  1, 1 ) + "】<font color='blue'>"