SQL Business Logic Exercises

Calculate completion rate per game level to identify difficulty spikes

Calculate average attempts per player per level to find bottlenecks

Calculate win rate per hero to identify overpowered characters

Calculate average match duration per game mode after timer changes

Count players per rank tier and their average rating

Calculate skill rating gap between matched players per game mode

Compare DAU and revenue across baseline, event, and post-event periods

Count daily active players across games to measure outage impact

Calculate average session duration per game to evaluate design changes

Summarize revenue and transactions per item category for store priorities

Calculate gold earned per source to find economy-flooding rewards

Calculate gold spent per sink type to evaluate currency drains

Calculate cost per install per channel to find efficient sources

Calculate purchase conversion rate per platform for monetization comparison

Calculate average sessions per player per day per game

Count monthly active players over three months to track growth

Calculate total playtime per player to identify VIP candidates

Count weekly active players to spot post-launch engagement trends

Calculate ARPU per game to compare monetization efficiency

Calculate ARPPU per game to measure spender depth