Your question is January Purchasers vs February. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Monee wants to identify users who purchased through the Monee app during January 2025 but made no purchase during February 2025. Write a PostgreSQL query that returns these January-only purchasers.
2025-01-01 through 2025-01-31 as a January purchase.2025-02-01 through 2025-02-28.user_id ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INTEGER | Unique Monee user identifier |
| full_name | VARCHAR(100) | User display name |
| signup_date | DATE | Date the user registered |
| Column | Type | Description |
|---|---|---|
| purchase_idPK | INTEGER | Unique purchase identifier |
| user_id | INTEGER | User who made the purchase |
| purchase_date | DATE | Date of the purchase |
| amount | NUMERIC(10,2) | Purchase amount |