Question

用SQL SERVER查询教师平均工资，如果平均工资大于5000元，则显示“收入水平较高”，否则显示“收入

Answer 1

if((select avg(工资) from 教师信息表)>5000 )
begin
(select '收入水平较高')
end
else
begin
(select '收入水平较低')
end

Answer 2

用存储过程写
salary 表示工资，teacher表
create proc p_avg
@avg_salary int output
as
begin
select @avg_salary =avg(salary) from teacher
if(@avg_salary >5000)
print '收入水平较高'
else
print '收入水平较低'
end
执行存储过程
declare @avg_salary int
exec p_avg @avg_salary output

Answer 3

select tno,case when avg(sal)>50000 then '收入水平较高' else '收入' end from teacher group by tno