Count Active Accounts

select count(*) as active_accounts
from ores.accounts
where valid_to = '9999-12-31 23:59:59'::timestamptz;