Solving the Continuous Check-in Bonus Calculation Problem in SQL
Problem Overview
This problem involves calculating bonus coins earned from consecutive daily check-ins. The challenge lies in correctly identifying continuous check-in periods and applying bonus rules at specific intervals.
Table Structure
Table: tb_user_log
Core Concepts
Bonus Rules
Base: 1 coin per day
Every 3rd consecutive day: +2 bonus coi ...
Posted on Tue, 22 Sep 2026 16:18:29 +0000 by something