easy5 pts · first answer countssqlquery-order

Column alias in WHERE fails

This query gives "column revenue does not exist". Why?

A.Aliases can only be one word written in capital lettersB.You cannot multiply two columns in a SELECTC.WHERE only accepts columns from a primary keyD.WHERE runs before SELECT, so the alias is not defined yet

Discussion 0

Join free to post in the discussion.

Column alias in WHERE fails

Discussion 0

Related questions