SELECT 

articul as "Артикул", 
SUM(CASE WHEN date_end >= Dateadd(month, DATEDIFF(MONTH,0, CURRENT_TIMESTAMP)-1,0) AND date_end < Dateadd(month, DATEDIFF(MONTH,0, CURRENT_TIMESTAMP),0) THEN tend_amt ELSE 0.00 END) as "Остаток,руб.", 
MAX(agent) as 'Агент'

FROM 
DBO
WHERE
date_start BETWEEN Dateadd(month, - 7, sysdatetime()) AND Dateadd(month, - 1, sysdatetime())
AND dep_code >1 AND dep_code ='5'
AND date_end in 
(
SELECT MAX(date_end)
from  DBO 
WHERE  date_end >= Dateadd(month, DATEDIFF(MONTH,0, CURRENT_TIMESTAMP)-1,0) AND date_end < Dateadd(month, DATEDIFF(MONTH,0, CURRENT_TIMESTAMP),0)
GROUP BY articul,dep_code
)


GROUP BY articul,dep_code
HAVING SUM( CASE WHEN date_end >= Dateadd(month, DATEDIFF(MONTH,0, CURRENT_TIMESTAMP)-1,0) AND date_end < Dateadd(month, DATEDIFF(MONTH,0, CURRENT_TIMESTAMP),0) THEN tend_amt ELSE 0.00 END) >=100000