Active Subscriptions

A SaaS company stores subscription data in the subscriptions table. A NULL end_date means the subscription is still active (no expiration set). Return the user_id and plan of all active subscriptions.

Example 1

Input:
id | user_id | plan | end_date
1  | 101     | pro  | 2024-06-30
2  | 102     | free | NULL
3  | 103     | pro  | NULL
4  | 104     | free | 2023-12-31
5  | 105     | pro  | NULL

Output:
user_id | plan
102     | free
103     | pro
105     | pro

Explanation

Users 102, 103, and 105 have no end date set. Users 101 and 104 have explicit expiration dates.

Constraints

• Return user_id and plan only
• A NULL end_date means the subscription is active