SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;


(No column name)


Microsoft SQL Server 2017 (RTM-CU12) (KB4464082) - 14.0.3045.24 (X64) 
	Oct 18 2018 23:11:05 
	Copyright (C) 2017 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)



CREATE TABLE SALESHS
(
    IDAREA INT,
    DATEREG [NVARCHAR](50) NOT NULL,
    IDPROD [NVARCHAR](50) NOT NULL
);

INSERT INTO SALESHS
(
 IDAREA, DATEREG, IDPROD
)
VALUES
(
 1, '2019-03-12', 'xplpc'
),
(
 1, '2019-03-15', 'ndtlctm'
),
(
 2, '2019-04-12', 'wntd'
)

3 rows affected

SELECT IDAREA, 
       SUM( CASE WHEN  YEAR(CAST(DATEREG AS DATETIME))= 2019 AND
                       MONTH(CAST(DATEREG AS DATETIME))=1 THEN
               1
            ELSE
               0
            END) JAN2019,
       SUM( CASE WHEN  YEAR(CAST(DATEREG AS DATETIME))= 2019 AND
                       MONTH(CAST(DATEREG AS DATETIME))=2 THEN
               1
            ELSE
               0
            END) FEB2019,
       SUM( CASE WHEN  YEAR(CAST(DATEREG AS DATETIME))= 2019 AND
                       MONTH(CAST(DATEREG AS DATETIME))=3 THEN
               1
            ELSE
               0
            END) MAR2019,
       SUM( CASE WHEN  YEAR(CAST(DATEREG AS DATETIME))= 2019 AND
                       MONTH(CAST(DATEREG AS DATETIME))=4 THEN
               1
            ELSE
               0
            END) APR2019            
 FROM saleshs
WHERE YEAR(CAST(DATEREG AS DATETIME))> 2017 
GROUP BY IDAREA
ORDER BY IDAREA


IDAREA
JAN2019
FEB2019
MAR2019
APR2019


1
0
0
2
0

2
0
0
0
1