SELECT COUNT(*) AS all_deals,
  COUNT(*) FILTER (WHERE is_annulled) AS annulled
FROM deals WHERE year = 2025
    all_dealsannulled
    1157638085