Final Gift Solution, Sql Server

Language: Layout:

CREATE TABLE mygifttable
( Date        datetime
 ,orderguid   varchar(10)
 ,description varchar(55)
 ,sku         int
 ,amount      decimal)
;
	
INSERT INTO mygifttable VALUES
    ('2017-06-01', '1234', 'Sony Speakers'   , 25, 100),
	('2017-06-01', '1234', 'Sony Tv'         , 23, 250),
    ('2017-06-01', '1234', 'Tv stand'        , 11, 0),
    
    ('2017-06-01', '1235', 'Samsung Speakers', 28, 150),
    ('2017-06-01', '1235', 'Samsung Tv'      , 26, 350),
    ('2017-06-01', '1235', 'Wall mount'      , 10, 0),
    
    ('2017-06-01', '1236', 'Sony Speakers'   , 25, 100),
    ('2017-06-01', '1236', 'Sony Tv'         , 23, 250),
    ('2017-06-01', '1236', 'Tv stand'        , 11, 0),
	
    ('2017-06-01', '1237', 'Apple mobiles'   , 29, 900),
    ('2017-06-01', '1237', 'Apple cable'     , 30, 800)
;

SELECT freegifttable.description
      ,SUM(freegifttable.freegift) as Free_Gifts
      ,SUM(totalamount.orderamount) as Total_Orderamount
  FROM (
         SELECT description
               ,orderguid
               ,SUM(IIF(amount = 0, 1,0)) as freegift
           FROM mygifttable
          GROUP BY description, orderguid
         HAVING SUM(IIF(amount = 0, 1,0)) != 0
       ) freegifttable
 INNER JOIN 
       (
           SELECT orderguid
                 ,SUM(amount) as orderamount
             FROM mygifttable
            GROUP BY orderguid      
        ) totalamount
    ON totalamount.orderguid = freegifttable.orderguid  
 GROUP BY freegifttable.description
 ;

View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 11, absolute service time: 0,17 sec