Complex~37min
The Velocity Mirage
Sprint velocity is up 150% since Sprint 12 and the PM is getting credit for "unblocking the team." Engineering throughput feels exactly the same to the engineers. The data will settle this.
Tables you'll query
team_memberssprintsticketsestimate_history
What you'll learn
CTEs (WITH clause)Window FunctionsAggregations & GROUP BYDate & Time Functions