Pricing plan for users on the waitlist

--waitlist
select
	distinct
	us.name,
	us.email,
	c.code as pricing_plan,
	c.amount,
	u.created_at::date as entered_credit_card_at
from user_events u
join coupons c
on c.id = json_extract_path_text(properties, 'coupon_id')
join analytics.acquisition_credit_card_source_tracking a
on a.user_id = u.user_id
and a.subscription_id is null
join users us
on us.id = u.user_id
where 
	event_name in ('Payment Form Completed', 'Requested Access')
	and u.created_at >= getdate() - '30 days'::interval
order by 5 desc