求解，with用法.该怎么处理

求解，with用法..

SQL code

withavg_salary(value) as(select avg(salary) from instructor)select ID,salaryfrom instructor,avg_salarywhere salary > avg_salary.value;