t, Sql Server - rextester

Language: Layout:

CREATE TABLE Map
    ([Id] varchar(1), [Quantity] int, [BizDate] datetime)
;
    
INSERT INTO Map
    ([Id], [Quantity], [BizDate])
VALUES
    ('A', 100, '2019-01-22 00:00:00'),
    ('B', 200, '2019-01-25 00:00:00'),
    ('A', 300, '2019-01-25 00:00:00'),
    ('B', 100, '2019-01-22 00:00:00'),
    ('C', 500, '2019-01-22 00:00:00'),
    ('D', 300, '2019-01-25 00:00:00'),
    ('A', 300, '2019-01-22 00:00:00')
;

with myView as (
    Select mp.Id, sum(mp.Quantity) counts 
    from Map mp 
    where mp.bizDate='22-Jan-2019' 
    group by mp.Id
)
SELECT *
FROM myView;

with myView as ( 
    Select mp.Id, 
           sum( CASE WHEN mp.bizDate='22-Jan-2019' 
                     THEN mp.Quantity
                     ELSE 0 
                END ) counts,
           sum( CASE WHEN mp.bizDate='25-Jan-2019' 
                     THEN mp.Quantity
                     ELSE 0 
                END ) quantity    
    from Map mp       
    group by mp.Id
)    
SELECT mv.Id, 
       counts,
       counts - quantity
FROM myView mv;

View schema
Execution time: 0,02 sec, rows selected: 7, rows affected: 7, absolute service time: 0,22 sec, absolute service time: 0,22 sec