How to alias Multiple table names

Hi, I am trying to select same value for all table names on InfluxDB, with these query
“SELECT mean(“value”) FROM /device_frmpayload_data_WaterMeter*/ WHERE $timeFilter GROUP BY time(15m) fill(null)”
I can get results but can not give custom names for each table. How can I change device_frmpayload_data_WaterMeter1.mean to WM1, device_frmpayload_data_WaterMeter2.mean to WM2 etc.