Hide Trial Tickets for Paying Members

Problem

A help desk stores support tickets in `tickets` with columns `(ticket_id, member_id, tier)`. `tier` is 0 for a 'paid' ticket and 1 for a 'trial' ticket. `ticket_id` is unique.

Report tickets using these rules:
- If a member has at least one paid ticket (tier = 0), do NOT report any of that member's trial tickets (tier = 1).
- Otherwise, report all of the member's tickets.

Return `ticket_id`, `member_id`, `tier` in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns ticket_id, member_id, tier.

Starter code (SQL)

SELECT *
FROM tickets;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium