江湖救急：帮我看看那里错了

Question

having ho_req<s_ho
    *
ERROR at line 12:
ORA-00904: invalid column name

Answer 1

select 
    int_id id,
    uuu uuu,
    AVG(aaa)+AVG(bbb)+AVG(ccc) a,
    AVG(ddd)+AVG(eee)+AVG(fff) b
FROM 
    table_name
where 
    to_char(start_time,'yyyy-mm-dd hh')='2004-07-31 10' 
group by 
    int_id,uuu
having 
    AVG(aaa)+AVG(bbb)+AVG(ccc)<AVG(ddd)+AVG(eee)+AVG(fff);