Does Filemaker's SQL's GROUP BY support aliases? -

Does Filemaker's SQL's GROUP BY support aliases? -

i'm having problem filemaker's sql commands.

select sum(energy) tot, hour(timepst) hr mydata grouping hr

gives me error:

the column "hr" not exist in table in column reference's scope.

is there way around this?

i believe need is:

select sum(energy) tot, hour(timepst) hr mydata grouping hour(timepst)

filemaker