Daily Betters in One Query

Identify users who have placed a bet every day for the last week using a single query for BetMGM.

Use the latest bet date in bets as the end of the seven-day period. Count a user as active for a day if they placed at least one bet that day.

Output

1. Return one row per qualifying user with user_id and username.
2. Include only users active on all seven calendar days.
3. Order by user_id ascending.