I can't make temp column in sql. 

Can you give me a suggestion?

Hi Jonatan,

You will need to better explain what's your goal, and why you need SQL vs an Aggregate?

Hi Jonatan,

Can you please explain little bit more what is your use-case.



Do you want to create an alias/calculated attribute?

In advanced SQL:
SELECT 'Alias' AS MyAlias

In aggregates:
Open the aggregate and click the + add new attribute button.
This allows you to add a custom named attribute in which you can enter an expression to calculate the required value.