Aggregated different column depending on value in another column

Archive
1

This might be more of a SQL question but anyway. I need to calculate count aggregate named lc_last depending on value in account_unsubscribed_at:

if account_unsubscribed_at is null as:

count (case when log_created_at > ({{ dbt_utils.current_timestamp }} - interval ‘30’ day) then 1 end) as lc_last_30d

if account_unsubscribed_at is not null as:

count (case when log_created_at > (account_unsubscribed_at - interval ‘30’ day) then 1 end) as lc_last_30d

How do I do that?

Thanks, Peter