Watch tutorials and explanations by expert teachers that walk through solving this problem.
NeetCode
CrioDo
NeetCodeIO
The Code Skool
The Query Lab
Everyday Data Science
Jimmy Giardiniera, SQL Extraordinaire
Ironfeet996
Solve more problems to master this pattern