1054. Unknown column 'ji.ag' in 'field list'

create view ji as select avg(salary) ag,department_id from employees group by department_id;
select ji.ag,g.grade_level from ji join job_grades g on ji.ag between g.lowest_sal and g.highest_sal;

应该不会报错啊，截个图看看