SQL - Advanced 3

The goal of this quest series is to improve your SQL skills
Goals
- Improve your SQL skills
Codewars Katas
You need to resolve this two Codewars Katas
↗
SQL Basics: Simple JOIN and RANK
codewars.com
↗
SQL Basics: Top 10 customers by total payments amount
codewars.com
Challenge
Codewars Katas
Once you have completed the katas, you can validate this quest yourself.