select * from (select toDate(datetime) as date, campaign_id, sum(sent_count) as sent, sum(delivered_count) as delivered, sum(unique_click_count) as clicks from channels_stat_daily where date >= '2024-11-01' group by date, campaign_id) where clicks < 30 order by date;