Duplicate table aliases SQL-L020

Table aliases should be unique within each clause. It is recommended to name the aliases differently.

Bad practice

SELECT name as foo, id as foo FROM table;

Recommended

SELECT name as foo, id as bar FROM table;