求出下表中在每一个工资发放日,每个部门的平均工资与公司的平均工资的比较结果 (高 / 低 / 相同)
期望结果如下:
建表语句:
-- Create table
create table LX_05_SALARY
(
id NUMBER,
department_name VARCHAR2(100),
sal NUMBER,
pay_date DATE
);
-- Add comments to the columns
comment on column LX_05_SALARY.department_name
is '部门';
comment on column LX_05_SALARY.sal
is '工资';
comment on column LX_05_SALARY.pay_date
is '发放日期';
–插入语句
insert into lx_05_salary (ID, DEPARTMENT_NAME, SAL, PAY_DATE)
values (1, 'A部门', 80000, to_date('10-01-2020', 'dd-mm-yyyy'));
commit;
insert into lx_05_salary (ID, DEPARTMENT_NAME, SAL, PAY_DATE)
values (2, 'B部门', 60000, to