create table tmp_b(a int,b int); create table tmp_a(a varchar(24),b int); insert into tmp_b select 1,13; insert into tmp_b select 2,13;

--Create test table create table tmp_test(empid int ,deptid int ,salary decimal(10,2) ); --Insert test data insert into tmp_test values (1,10,5500.00), (2,10,4500.00), (3,20,1900.00), (4,20,