Watch tutorials and explanations by expert teachers that walk through solving this problem.
NeetCode
NeetCodeIO
Goodly
SQL and Database explained!
Everyday Data Science
Solve more problems to master this pattern