SELECT customer_id,
       CASE WHEN purchase_amount = 0 THEN 'No Purchase'
            ELSE NULLIF(purchase_amount, 0)
       END AS purchase_status
FROM customers;