do you know window function and what is difference between dense rank and rank
Sigiloso
window function helps to group by additional condition it make a window for each criteria and rank skips the next rank in case of duplicates while dense rank doesn't skip next rank in case of duplicate ( with example)