为什么此sql查询给出错误?
SELECT
dt_created AS "time",humidity,((temp* 1.8) + 32) AS temp_f,(-42.379 + 2.04901523 * temp_f + 10.14333127*humidity - .22475541* temp_f * humidity - .00683783 * temp_f* temp_f - .05481717*humidity*humidity + .00122874 * temp_f * temp_f*humidity + .00085282 * temp_f*humidity*humidity - .00000199 * temp_f * temp_f*humidity*humidity) AS "Feels Like"
FROM particle_photon
WHERE
dt_created BETWEEN FROM_UNIXTIME(1572739408) AND FROM_UNIXTIME(1572825808)
ORDER BY dt_created;
错误为Error 1054: Unknown column 'temp_f' in 'field list'
但是我确实以别名声明了temp_f
!