日期:2014-05-16 浏览次数:20844 次
with avg_salary(value) as(select avg(salary) from instructor) select ID,salary from instructor,avg_salary where salary > avg_salary.value;