问1111 (HY000)：组函数使用无效|无法在部分查询中使用组函数

EN

THEN count(DISTINCT(workflow_link.email_api_response_packets.parent_id))

SELECT workflow_link.email_api_response_packets.subscriber_id
     , count(DISTINCT(workflow_link.email_api_response_packets.parent_id)) as cnt
     , SUM(CASE WHEN (workflow_link.email_api_response_packets.action = 'O'
                      AND workflow_link.email_api_response_packets.parent_id IS NOT NULL
                THEN count(DISTINCT(workflow_link.email_api_response_packets.parent_id))
                ELSE 0
                END)*100/SUM(CASE WHEN (workflow_link.email_api_response_packets.id
                                        AND workflow_link.email_api_response_packets.parent_id IS NULL)
                                  THEN 1
                                  ELSE 0
                                  END) AS percentage
FROM workflow_link.email_api_response_packets
WHERE workflow_link.email_api_response_packets.updated_at >= 1403929223
    AND workflow_link.email_api_response_packets.updated_at <= 1503929479
    AND workflow_link.email_api_response_packets.list_id IN (400)
    AND workflow_link.email_api_response_packets.is_test = 0
GROUP BY workflow_link.email_api_response_packets.subscriber_id
HAVING percentage >= 0