You can change column names or supply column names for calculations using as in the Select clause, such as this example that changes a column name:

Examples of queries using as to provide column names for calculations are shown in Use Plain Functions to Update, Select or Sort Rows, Group and Analyze Rows and Group and Analyze Rows with Row Detail.

For more information, see also Use Alias Names in Other Clauses, Use Alias Names to Handle HTML Column Content and Valid Names for Datasets, Columns, Aliases, Paths and Functions.