payments AS (
SELECT toDate(ContractCharge_TM) AS PaymentDate,
       uid,
       SUM(USDNet) AS TotalUSDNet,
       SUM(USDNet) > 0 AS TotalPurchase,
       SUM(IF(concat(Type, Value) IN ('purchase_minutes_1', 'purchase_minutes_180', 'purchase_minutes_30', 'purchase_minutes_90', 'subscription_minutes_30', 'subscription_minutes_365', 'subscription_minutes_7'), USDNet, 0)) AS MinutesUSDNet,
       SUM(IF(USDNet > 0
              AND concat(Type, Value) IN ('purchase_minutes_1', 'purchase_minutes_180', 'purchase_minutes_30', 'purchase_minutes_90', 'subscription_minutes_30', 'subscription_minutes_365', 'subscription_minutes_7'), 1, 0)) AS MinutesPurchase,
       SUM(IF(concat(Type, Value) IN ('subscription_30', 'subscription_365'), USDNet, 0)) AS SubscriptionUSDNet,
       SUM(IF(concat(Type, Value) IN ('subscription_30', 'subscription_365'), 1, 0)) AS SubscriptionPurchase,
       SUM(IF(Sku LIKE '%care_plus%' OR Sku LIKE '%premium%', USDNet, 0)) AS PlusSubscriptionUSDNet,
       SUM(IF(Sku LIKE '%care_plus%' OR Sku LIKE '%premium%', 1, 0)) AS PlusSubscriptionPurchase
FROM analytics.money join exp_users using(uid)
WHERE ChargeNumber >= 1
  AND NOT was_refunded
  AND USDNet >= 0.02
  AND ContractCharge_TM >= '2024-01-01'
GROUP BY PaymentDate, uid
),