56,679
社区成员
发帖
与我相关
我的任务
分享
select a_id,
count(q_id) as a_id相同的q_id一共有几个,
sum(start_date>curdate()) as start_date大于今天的有几个,
sum(end_date<curdate()) as end_date小于今天的有几个,
sum(curdate() between start_date and end_date) as start_date中间end_date包括今天的有几个
from 假设有一张表
group by a_id