How to move data from a colons to another?

i must be simple but i don’t found it how to do it
from the print screen

how to move the datas from the avarage into temp_mix

and after this how to delete the colums average?

have a nice day

Hello @vinc,
There isn’t an easy way to do this in InfluxQL. This is achievable easily with Flux however. Are you running 1.8+?