一个简单的解决方案是使用嵌套查询：

select substitute, order_date from 
(select json_extract(other_detail,'$.is_substitute_allowed') as substitute,
       count(date(order_date)) as order_date 
from prescription_metrics)
group by 1;

顺便说一句，你是说 count(distinct(order_date)) 或任何其他日期操纵( day ？）在“订单日期”列中？

请尝试下面的查询，

select json_extract(other_detail,'$.is_substitute_allowed') as substitute, count(date(order_date)) as order_date from prescription_metrics group by json_extract(other_detail,'$.is_substitute_allowed');