Find Active Subscribers with Valid Billing in SQL

Question

You have a `subscribers` table. Write a SQL query to find all users whose account status is 'active' and who have verified their payment method (`payment_verified_at` IS NOT NULL). Return `user_id`, `plan_name`, and `signup_date` sorted by `signup_date` descending.

Accepted Answer

Optimal Solution:
SELECT user_id, plan_name, signup_date
FROM subscribers
WHERE status = 'active'
  AND payment_verified_at IS NOT NULL
ORDER BY signup_date DESC;

Technical Explanation:
The query filters rows using two conjunctions: an equality check on `status` and a null check with `IS NOT NULL`. It then orders the matching rows by `signup_date` in descending order.

user_id	plan_name	status	payment_verified_at	signup_date
101	Pro Monthly	active	2026-01-15	2026-01-14
102	Free Trial	active	NULL	2026-02-01
103	Pro Annual	paused	2025-11-20	2025-11-19
104	Pro Monthly	active	2026-02-10	2026-02-10

user_id	plan_name	signup_date
104	Pro Monthly	2026-02-10
101	Pro Monthly	2026-01-14