CONVERT MySQL to MS SQL

SELECT
p.pcode,
p.productName,
CASE
        WHEN gr_rows IS NULL AND sl_rows IS NULL THEN 0
        WHEN gr_rows > 0 AND sl_rows IS NULL THEN received_stock
        WHEN gr_rows > 0 AND sl_rows > 0 THEN opening_stock
        ELSE 0
    END AS op_stock,
    IFNULL(received_stock, 0),IFNULL(sold_stock, 0)
FROM tbl_products p
LEFT JOIN (
    SELECT COUNT(r.ID) AS gr_rows,r.pcode,r.received_on,SUM(r.received_qty) AS received_stock
    FROM tbl_shop_gr_items r
    WHERE r.received_on = '2019-10-03'
    GROUP BY r.pcode
)AS r ON p.pcode = r.pcode
LEFT JOIN (
    SELECT COUNT(s.ID) AS sl_rows,s.pcode,s.date_created,SUM(s.soldQty) AS sold_stock
    FROM tbl_sold_items s
    WHERE s.date_created = '2019-10-03'
    GROUP BY s.pcode
)AS s ON p.pcode = s.pcode
LEFT JOIN (
    SELECT t.ID,t.pcode,t.date_created,t.remaining_qty AS opening_stock
    FROM tbl_sold_items t
    WHERE t.date_created > '2019-10-03'
    GROUP BY t.pcode ORDER BY t.ID
)AS t ON p.pcode = t.pcode