Comment by hantusk

CTEs go a long way towards left to right readability while keeping everything standard SQL.