That's a fantastic breakdown of the problem, your SQL strategy is really clear and well-explained