MySQL Join Query | Dataford Interview Questions

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.

Requirements

Include every active loyalty member, including members with no qualifying redemption.
Count Q1 2025 redemptions and calculate total points used, treating missing points as zero.
Add a redemption_status column with Redeemed or No redemption, then sort by points used descending and member ID ascending.

Schema

loyalty_members

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

reward_redemptions

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

Your question is MySQL Join Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem