AlthoughSELECTis syntax-wise named as the first clause (with the exception of those queries using aWITHclause: not discussed here), it is not executed first. Notably,SELECTis not the last clause to execute either. An expression (or any column) can be given a reference name orALIASin th...