Check this:
DECLARE @tmp TABLE (id INT IDENTITY(1,1), amount INT, businessVolume INT, Dueno INT, advisor_id INT)
INSERT INTO @tmp (amount, businessVolume, Dueno, advisor_id)
VALUES(500, 50, 1, 1), (1000, 100, 2, 1),
(500, 50, 15, 1), (1000, 100, 3, 1),
(500, 50, 2, 2), (1000, 100, 3, 2),
(500, 50, 13, 2)
SELECT t1.advisor_id, (SELECT SUM(amount) FROM @tmp WHERE advisor_id = t1.advisor_id) AS SumOfAmount, SUM(t1.businessVolume) AS SumOfBissVol
FROM @tmp AS t1
WHERE Dueno <13
GROUP BY advisor_id
Result:
adv._id Amount Buss.Vol
1 3000 250
2 2000 150