It does the second you want to join to the results of that subquery...this is an optimization that recognizes that the alias is never used and thus can be omitt

It does the second you want to join to the results of that subquery...this is an optimization that recognizes that the alias is never used and thus can be omitted. Nice QOL feature.