I think 201809 is not an outlier as percentage deviation is less than 20% for amount1 and less than 10 % for amount2

CREATE TABLE dbo.Transactions(
 Date1 Varchar(6) Not...

create table #temp
(
    prodID int
    ,mktID nvarchar(255)
    ,rev decimal
    ,qty decimal
)

insert into #temp (prodID, mktID, rev, qty)
values (1, 'a', 100, 10)
insert into...

Its is for Microsoft SQL Server 2014

I read this Query from Question of the day post. Was trying to learn about triggers.

So my query is since the trigger is updating the Questions table