MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `item` (
  `item_code` varchar(20) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_price` bigint(20) NOT NULL,
  `item_stock` int(11) NOT NULL DEFAULT 0,
  `item_images` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `item` (`item_code`, `item_name`, `item_price`, `item_stock`, `item_images`) VALUES
('xx1', 'BULB HEADLIGHT', 50000, 32, 'noimage.png'),
('xx2', 'BULB TAILLIGHT', 1000, 100, 'noimage.png'),
('xx3', 'ELEMENT COMP, AIR CLEANER', 20000, 98, 'noimage.png'),
('xx4', 'HONDA M/C GENUINE COOLANT', 15000, 150, 'noimage.png'),
('xx5', 'MPX1 10W30 SLMA 0,8L CAS', 13000, 50, 'noimage.png'),
('xx6', 'OLI SPX2 10W30 SL 0,8L REP', 15000, 200, 'noimage.png'),
('xx7', 'PAD SET FR', 12000, 70, 'noimage.png'),
('xx8', 'WEIGHT SET CLUTCH', 10000, 90, 'noimage.png');


CREATE TABLE `sales_details` (
  `sd_id` int(11) NOT NULL,
  `sales_code` varchar(20) NOT NULL,
  `item_code` varchar(20) NOT NULL,
  `sd_qty` int(11) NOT NULL,
  `sd_total` bigint(20) NOT NULL,
  `sd_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `sales_details` (`sd_id`, `sales_code`, `item_code`, `sd_qty`, `sd_total`, `sd_date`) VALUES
(1, 'INVPJ2042267826', 'xx1', 1, 50000, '2020-01-01'),
(2, 'INVPJ2042127826', 'xx1', 5, 250000, '2020-01-16'),
(3, 'INVPJ2042127826', 'xx1', 12, 600000, '2020-01-29'),
(4, 'INVPJ2042127826', 'xx2', 25, 25000, '2020-01-29'),
(6, 'INVPJ2042127826', 'xx4', 22, 330000, '2020-01-29'),
(7, 'INVPJ2042127826', 'xx5', 187, 2431000, '2020-01-29'),
(8, 'INVPJ2042127821', 'xx6', 48, 720000, '2020-01-29'),
(9, 'INVPJ2042127821', 'xx7', 33, 396000, '2020-01-29'),
(10, 'INVPJ2042127821', 'xx8', 3, 30000, '2020-01-29'),
(11, 'INVPJ2042127444', 'xx1', 22, 1100000, '2020-02-12'),
(12, 'INVPJ2042127444', 'xx2', 22, 22000, '2020-02-12'),
(13, 'INVPJ2042127444', 'xx3', 34, 680000, '2020-02-12'),
(14, 'INVPJ2042127444', 'xx4', 25, 375000, '2020-02-12'),
(15, 'INVPJ2042127454', 'xx5', 173, 2249000, '2020-02-12'),
(16, 'INVPJ2042127454', 'xx6', 97, 1455000, '2020-02-12'),
(17, 'INVPJ2042127454', 'xx7', 27, 324000, '2020-02-12'),
(18, 'INVPJ2042127457', 'xx8', 7, 70000, '2020-02-12'),
(19, 'INVPJ2042127451', 'xx1', 16, 800000, '2020-03-12'),
(20, 'INVPJ2042127451', 'xx2', 23, 23000, '2020-03-12'),
(21, 'INVPJ2042127451', 'xx3', 32, 640000, '2020-03-12'),
(22, 'INVPJ2042127451', 'xx4', 15, 225000, '2020-03-12'),
(23, 'INVPJ2042127452', 'xx5', 142, 1846000, '2020-03-12'),
(24, 'INVPJ2042127452', 'xx6', 75, 1125000, '2020-03-12'),
(25, 'INVPJ2042127452', 'xx7', 40, 480000, '2020-03-12'),
(26, 'INVPJ2042127452', 'xx8', 9, 90000, '2020-03-12'),
(27, 'INVPJ2052127452', 'xx1', 19, 950000, '2020-04-12'),
(28, 'INVPJ2052127452', 'xx2', 24, 24000, '2020-04-12'),
(29, 'INVPJ2052127452', 'xx3', 29, 580000, '2020-04-12'),
(30, 'INVPJ2052127451', 'xx4', 34, 510000, '2020-04-12'),
(31, 'INVPJ2052127451', 'xx5', 196, 2548000, '2020-04-12'),
(32, 'INVPJ2052127451', 'xx6', 114, 1710000, '2020-04-12'),
(33, 'INVPJ2052127451', 'xx7', 20, 240000, '2020-04-12'),
(34, 'INVPJ2052127451', 'xx8', 8, 80000, '2020-04-12'),
(35, 'INVPJ2052127455', 'xx1', 18, 900000, '2020-05-12'),
(36, 'INVPJ2052127455', 'xx2', 16, 16000, '2020-05-12'),
(37, 'INVPJ2052127455', 'xx3', 32, 640000, '2020-05-12'),
(38, 'INVPJ2052127455', 'xx4', 35, 525000, '2020-05-12'),
(39, 'INVPJ2052127455', 'xx5', 118, 1534000, '2020-05-12'),
(40, 'INVPJ2052127455', 'xx6', 247, 3705000, '2020-05-12'),
(41, 'INVPJ2052128455', 'xx7', 40, 480000, '2020-05-12'),
(42, 'INVPJ2052128455', 'xx8', 18, 180000, '2020-05-12'),
(43, 'INVPJ2052128451', 'xx1', 24, 1200000, '2020-06-12'),
(44, 'INVPJ2052128451', 'xx2', 14, 14000, '2020-06-12'),
(45, 'INVPJ2052128451', 'xx3', 38, 760000, '2020-06-12'),
(46, 'INVPJ2052128451', 'xx4', 25, 375000, '2020-06-12'),
(47, 'INVPJ2052128451', 'xx5', 218, 2834000, '2020-06-12'),
(48, 'INVPJ2052128452', 'xx6', 51, 765000, '2020-06-12'),
(49, 'INVPJ2052128452', 'xx7', 37, 444000, '2020-06-12'),
(50, 'INVPJ2052128452', 'xx8', 9, 90000, '2020-06-12'),
(51, 'INVPJ2052128453', 'xx1', 21, 1050000, '2020-07-12'),
(52, 'INVPJ2052128453', 'xx2', 19, 19000, '2020-07-12'),
(53, 'INVPJ2052128453', 'xx3', 24, 480000, '2020-07-12'),
(54, 'INVPJ2052128453', 'xx4', 42, 630000, '2020-07-12'),
(55, 'INVPJ2052128453', 'xx5', 163, 2119000, '2020-07-12'),
(56, 'INVPJ2052128454', 'xx6', 89, 1335000, '2020-07-12'),
(57, 'INVPJ2052128454', 'xx7', 46, 552000, '2020-07-12'),
(58, 'INVPJ2052128454', 'xx8', 12, 120000, '2020-07-12'),
(59, 'INVPJ2213124121', 'xx1', 22, 1100000, '2020-08-12'),
(60, 'INVPJ2213124121', 'xx2', 17, 17000, '2020-08-12'),
(61, 'INVPJ2213124121', 'xx3', 30, 600000, '2020-08-12'),
(62, 'INVPJ2213124121', 'xx4', 41, 615000, '2020-08-12'),
(63, 'INVPJ2213124122', 'xx5', 257, 615000, '2020-08-12'),
(64, 'INVPJ2213124122', 'xx6', 157, 2355000, '2020-08-12'),
(65, 'INVPJ2213124122', 'xx7', 35, 420000, '2020-08-12'),
(66, 'INVPJ2213124122', 'xx8', 7, 70000, '2020-08-12'),
(67, 'INVPJ2213124123', 'xx1', 25, 1250000, '2020-09-12'),
(68, 'INVPJ2213124123', 'xx2', 13, 13000, '2020-09-12'),
(69, 'INVPJ2213124123', 'xx3', 25, 500000, '2020-09-12'),
(70, 'INVPJ2213124124', 'xx4', 21, 315000, '2020-09-12'),
(71, 'INVPJ2213124124', 'xx5', 98, 1274000, '2020-09-12'),
(72, 'INVPJ2213124124', 'xx6', 80, 1200000, '2020-09-12'),
(73, 'INVPJ2213124125', 'xx7', 30, 360000, '2020-09-12'),
(74, 'INVPJ2213124125', 'xx8', 11, 110000, '2020-09-12'),
(75, 'INVPJ2213124126', 'xx1', 18, 900000, '2020-10-12'),
(76, 'INVPJ2213124126', 'xx2', 19, 19000, '2020-10-12'),
(77, 'INVPJ2213124126', 'xx3', 25, 500000, '2020-10-12'),
(78, 'INVPJ2213124126', 'xx4', 39, 585000, '2020-10-12'),
(79, 'INVPJ2213124127', 'xx5', 138, 1794000, '2020-10-12'),
(80, 'INVPJ2213124127', 'xx6', 161, 2415000, '2020-10-12'),
(81, 'INVPJ2213124127', 'xx7', 34, 408000, '2020-10-12'),
(82, 'INVPJ2213124127', 'xx8', 8, 80000, '2020-10-12');
SELECT a.item_code,
       COALESCE(SUM(b.sd_qty), 0) total,
       DATE_FORMAT(d.sd_date, '%m-%Y') month_year
FROM item a 
CROSS JOIN (
  SELECT DISTINCT sd_date 
  FROM sales_details 
  WHERE sd_date >= '2020-04-01' - INTERVAL 3 MONTH AND sd_date < '2020-05-01'
) d 
LEFT JOIN sales_details b 
ON a.item_code = b.item_code AND b.sd_date = d.sd_date
GROUP BY month_year, a.item_code
ORDER BY month_year, a.item_code;


item_code
total
month_year


xx1
18
01-2020

xx2
25
01-2020

xx3
0
01-2020

xx4
22
01-2020

xx5
187
01-2020

xx6
48
01-2020

xx7
33
01-2020

xx8
3
01-2020

xx1
22
02-2020

xx2
22
02-2020

xx3
34
02-2020

xx4
25
02-2020

xx5
173
02-2020

xx6
97
02-2020

xx7
27
02-2020

xx8
7
02-2020

xx1
16
03-2020

xx2
23
03-2020

xx3
32
03-2020

xx4
15
03-2020

xx5
142
03-2020

xx6
75
03-2020

xx7
40
03-2020

xx8
9
03-2020

xx1
19
04-2020

xx2
24
04-2020

xx3
29
04-2020

xx4
34
04-2020

xx5
196
04-2020

xx6
114
04-2020

xx7
20
04-2020

xx8
8
04-2020


WITH RECURSIVE dates AS (
  SELECT '2020-04-01' - INTERVAL 3 MONTH AS sd_date
  UNION ALL
  SELECT sd_date + INTERVAL 1 MONTH
  FROM dates 
  WHERE sd_date + INTERVAL 1 MONTH < '2020-05-01'
)
SELECT a.item_code,
       COALESCE(SUM(b.sd_qty), 0) total,
       DATE_FORMAT(d.sd_date, '%m-%Y') month_year
FROM item a CROSS JOIN dates d 
LEFT JOIN sales_details b 
ON a.item_code = b.item_code AND DATE_FORMAT(b.sd_date, '%m-%Y') = DATE_FORMAT(d.sd_date, '%m-%Y')
GROUP BY month_year, a.item_code
ORDER BY month_year, a.item_code;


item_code
total
month_year


xx1
18
01-2020

xx2
25
01-2020

xx3
0
01-2020

xx4
22
01-2020

xx5
187
01-2020

xx6
48
01-2020

xx7
33
01-2020

xx8
3
01-2020

xx1
22
02-2020

xx2
22
02-2020

xx3
34
02-2020

xx4
25
02-2020

xx5
173
02-2020

xx6
97
02-2020

xx7
27
02-2020

xx8
7
02-2020

xx1
16
03-2020

xx2
23
03-2020

xx3
32
03-2020

xx4
15
03-2020

xx5
142
03-2020

xx6
75
03-2020

xx7
40
03-2020

xx8
9
03-2020

xx1
19
04-2020

xx2
24
04-2020

xx3
29
04-2020

xx4
34
04-2020

xx5
196
04-2020

xx6
114
04-2020

xx7
20
04-2020

xx8
8
04-2020
item_code	total	month_year
xx1	18	01-2020
xx2	25	01-2020
xx3	0	01-2020
xx4	22	01-2020
xx5	187	01-2020
xx6	48	01-2020
xx7	33	01-2020
xx8	3	01-2020
xx1	22	02-2020
xx2	22	02-2020
xx3	34	02-2020
xx4	25	02-2020
xx5	173	02-2020
xx6	97	02-2020
xx7	27	02-2020
xx8	7	02-2020
xx1	16	03-2020
xx2	23	03-2020
xx3	32	03-2020
xx4	15	03-2020
xx5	142	03-2020
xx6	75	03-2020
xx7	40	03-2020
xx8	9	03-2020
xx1	19	04-2020
xx2	24	04-2020
xx3	29	04-2020
xx4	34	04-2020
xx5	196	04-2020
xx6	114	04-2020
xx7	20	04-2020
xx8	8	04-2020