SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE VchrDMonSum(year int,month int,orgCompany nvarchar(10),Bid int,AmtOrg int);
insert into VchrDMonSum
values (2020,3,'JU',100,1000),
(2020,3,'JU',110,2000),
(2020,3,'JU',120,3000),
(2020,3,'JU',130,4000),
(2020,3,'JU',620,5000),
(2020,3,'JU',640,6000),
(2020,3,'JU',900,7000),
(2020,3,'JU',910,8000),
(2020,3,'Jx',920,19000),
(2020,2,'Jy',100,29000),
(2019,3,'JU',900,39000);
11 rows affected

select sum(AmtOrg)/3/1000.0
from VchrDMonSum
where orgCompany='JU'
and year=2020
and month<=3
and (Bid=100 or Bid=110 or Bid=120 or Bid=130)


(No column name)


3.333000


select sum(AmtOrg)/3/1000.0
from VchrDMonSum
where orgCompany='JU'
and year=2020
and month<=3
and (Bid=620 or Bid=640 or Bid=900 or Bid=910 or Bid=920)


(No column name)


8.666000


CREATE TABLE Fee0051Cost(FinalOrd float);
select *
from Fee0051Cost


FinalOrd


insert Fee0051Cost(FinalOrd)
select sum(AmtOrg)/3/1000.0
from VchrDMonSum
where orgCompany='JU'
and year=2020
and month<=3
and (Bid=100 or Bid=110 or Bid=120 or Bid=130)
--
union all
select sum(AmtOrg)/3/1000.0
from VchrDMonSum
where orgCompany='JU'
and year=2020
and month<=3
and (Bid=620 or Bid=640 or Bid=900 or Bid=910 or Bid=920)
2 rows affected

select *
from Fee0051Cost


FinalOrd


3.333

8.666