> you cannot use aliases defined in SELECT in following clauses Some DBs allow it or allow it partially. It's a major constant friction factor for me to do a g

> you cannot use aliases defined in SELECT in following clauses Some DBs allow it or allow it partially. It's a major constant friction factor for me to do a guess work across different database systems.