Given two tables, write a query to find users who haven't made a transaction in the last 30 days.
Use PostgreSQL's CURRENT_DATE as the reference date. Treat transactions from CURRENT_DATE - INTERVAL '30 days' through CURRENT_DATE as recent.
user_id and full_name.user_id ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique identifier for a user |
| full_name | VARCHAR(150) | User's display name |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique identifier for a transaction |
| user_id | INT | User who made the transaction |
| transaction_date | DATE | Date on which the transaction occurred |
| amount | NUMERIC(12,2) | Transaction amount |