What SQL queries have you practiced that involve window functions?

Technical