晓多银河系统如何查询官网按钮点击数，计算点击转化率！

SELECT *
FROM dwd.growth_behavior
WHERE day BETWEEN '2025-08-01' AND '2025-08-02'
and source='晓多官网'
and (click_title='免费试用' or click_title='立即试用' or click_title='立即登录')

SELECT anonymous_id,COUNT(anonymous_id) AS '点击次数'
FROM dwd.growth_behavior
WHERE day BETWEEN '2025-08-01' AND '2025-08-02'
and source='晓多官网'
and (click_title='免费试用' or click_title='立即试用' or click_title='立即登录')
GROUP BY anonymous_id;