MariaDB 10.3

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

CREATE TABLE sales (
    id int auto_increment primary key,
    customerID VARCHAR(255),
    sales_date DATE,
    sales_volume INT,
    annual_unqiue_count INT
);

INSERT INTO sales
(customerID, sales_date, sales_volume, annual_unqiue_count)
VALUES 
("Customer_01", "2020-03-01", "600", "1"),
("Customer_01", "2020-03-25", "315", "0"),

("Customer_02", "2020-03-18", "208", "1"),
("Customer_02", "2020-07-25", "140", "0"),

("Customer_03", "2020-10-18", "400", "1"),
("Customer_03", "2020-12-06", "500", "0"),
("Customer_03", "2020-12-18", "438", "0"),
("Customer_03", "2020-12-25", "917", "0");

SELECT
customerID,
sales_date,
SUM(annual_unqiue_count),
SUM(sales_volume)
FROM sales
GROUP BY 1,2;


customerID
sales_date
SUM(annual_unqiue_count)
SUM(sales_volume)


Customer_01
2020-03-01
1
600

Customer_01
2020-03-25
0
315

Customer_02
2020-03-18
1
208

Customer_02
2020-07-25
0
140

Customer_03
2020-10-18
1
400

Customer_03
2020-12-06
0
500

Customer_03
2020-12-18
0
438

Customer_03
2020-12-25
0
917


SELECT
customerID,
sales_date,
SUM(annual_unqiue_count),
SUM(sales_volume)
FROM sales
GROUP BY 1,2
HAVING SUM(annual_unqiue_count) <> 0;


customerID
sales_date
SUM(annual_unqiue_count)
SUM(sales_volume)


Customer_01
2020-03-01
1
600

Customer_02
2020-03-18
1
208

Customer_03
2020-10-18
1
400

customerID	sales_date	SUM(annual_unqiue_count)	SUM(sales_volume)
Customer_01	2020-03-01	1	600
Customer_01	2020-03-25	0	315
Customer_02	2020-03-18	1	208
Customer_02	2020-07-25	0	140
Customer_03	2020-10-18	1	400
Customer_03	2020-12-06	0	500
Customer_03	2020-12-18	0	438
Customer_03	2020-12-25	0	917