Are they a good or bad customer
SELECT T1.good_or_bad_customer FROM customers AS T1 JOIN discount_coupons AS T2 ON T1.coupon_id   =   T2.coupon_id WHERE T2.coupon_amount   =   500
good or bad customer status is determined by the presence of a discount coupon with a specific amount (e.g., 500);