Well, then you'd have two columns named max
, which isn't very useful!
To avoid situations like this, SQL allows you to do something called aliasing. Aliasing simply means you assign a temporary name to something. To alias, you use the AS
keyword, which you've already seen earlier in this course.
For example, in the above example we could use aliases to make the result clearer: