Using aliases with out measurement title?

How can I get my alias to just be “Air Pump” instead of “Flows.Air Pump” ? The picture above better shows what I am trying to do.

What you have works ok for me (I don’t see measurement.column), though I am using avg(column). I am using Influx, though whether that makes a difference I don’t know.
So my equivalent query is

  avg(t_greenhouse) AS "t_greenhouse", avg(t_external) AS "t_external"
FROM samples
ORDER BY $__timeGroup(measured_at,$__interval)

I was able to solve this problem by adding $col to the “ALIAS BY” field

Just to clarify, what SQL have you ended up with?

I am using InfluxQL.