MySQL 8.0

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

CREATE TABLE mytable(
   date DATE  NOT NULL 
  ,name VARCHAR(13) NOT NULL
  ,code INTEGER  NOT NULL
);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-01','category1',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-02','category1',1);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-03','category1',2);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-04','category1',3);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-05','category1',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-06','category1',1);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-07','category1',2);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-08','category1',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-01','category2',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-02','category2',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-03','category2',1);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-04','category2',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-05','category2',1);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-06','category2',2);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-07','category2',0);
INSERT INTO mytable(date,name,code) VALUES ('2020-01-08','category2',1);

date	name	code
2020-01-04	category1	3
2020-01-07	category1	2
2020-01-03	category2	1
2020-01-06	category2	2