Your question is MySQL Join Query. 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.
Kobie Marketing needs a redemption summary for active members in a Kobie loyalty program. Write a PostgreSQL query that joins member records with reward redemptions and reports activity during the first quarter of 2025.
redemption_status column with Redeemed or No redemption, then sort by points used descending and member ID ascending.| Column | Type | Description |
|---|---|---|
| member_idPK | INTEGER | Unique loyalty member identifier |
| member_name | VARCHAR(100) | Member's full name |
| member_status | VARCHAR(20) | Current membership status |
| Column | Type | Description |
|---|---|---|
| redemption_idPK | INTEGER | Unique redemption identifier |
| member_id | INTEGER | References loyalty_members.member_id |
| redeemed_at | DATE | Redemption date |
| points_used | INTEGER | Points spent in the redemption |
| redemption_channel | VARCHAR(30) | Channel where the redemption occurred |