mysql语法问题
select (`aaa`/`bbb`) as ccc
from test
where ccc > 1
搜寻是没问题，但是加上where条件会说[err] 1054 - unknown column 'ccc' in 'where clause'，请问要怎么修正?
------解决思路----------------------
select (`aaa`/`bbb`) as ccc
from test
where `aaa`/`bbb` > 1
或
select (`aaa`/`bbb`) as ccc
from test
having ccc > 1
注意：`aaa`/`bbb` 不会被重复计算