Incorrect Refer to a column alias causing performance degradation

For easy of referencing and better code readability we add aliases to table reference in most of queries. For correlated queries we add conditions based on correlation columns between any two tables or entities. Below is one of query shared by the application team causing performance degradations due to incorrect use of column aliases. Let…