CASE

WHEN MEMO IS NOT NULL AND MEMO != '' THEN 'With Memo'

ELSE 'Without Memo'

END AS memo_status,

COUNT(*) AS transaction_count

FROM stellar.core.fact_transactions

GROUP BY memo_status