MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table input (pickdate date, picknumber varchar(40), plant varchar(20));
insert into input values
('2022-01-03','L009803','Seattle'),
('2022-01-03','L009803','Seattle'),
('2022-01-03','L009803','Seattle'),
('2022-01-20','L19033','Irving'),
('2022-01-21','KL89231','Mini chih'),
('2022-01-23','MY12341','kettle'),
('2022-01-23','MY12341','kettle'),
('2022-01-25','FD1211','Seattle'),
('2022-01-26','HJ12W1','Irving'),
('2022-02-11','K231245','Irving'),
('2022-02-11','K231245','Irving'),
('2022-02-15','N12ER1','Mini chih'),
('2022-02-21','JS1234','Irving'),
('2022-02-25','MK12E1','Kettle');
SELECT DATE_FORMAT(pickdate, '%b-%y') Time_period,
       COUNT(DISTINCT CASE WHEN plant = 'Seattle' THEN picknumber END) Seattle,
       COUNT(DISTINCT CASE WHEN plant = 'Irving' THEN picknumber END) Irving,
       COUNT(DISTINCT CASE WHEN plant = 'Mini chih' THEN picknumber END) Mini_chih,
       COUNT(DISTINCT CASE WHEN plant = 'kettle' THEN picknumber END) kettle
FROM input
GROUP BY Time_period
ORDER BY STR_TO_DATE(CONCAT('01-', Time_period), '%d-%b-%y');


Time_period
Seattle
Irving
Mini_chih
kettle


Jan-22
2
2
1
1

Feb-22
0
2
1
1


SELECT DATE_FORMAT(pickdate, '%Y-%m') Time_period,
       COUNT(DISTINCT CASE WHEN plant = 'Seattle' THEN picknumber END) Seattle,
       COUNT(DISTINCT CASE WHEN plant = 'Irving' THEN picknumber END) Irving,
       COUNT(DISTINCT CASE WHEN plant = 'Mini chih' THEN picknumber END) Mini_chih,
       COUNT(DISTINCT CASE WHEN plant = 'kettle' THEN picknumber END) kettle
FROM input
GROUP BY Time_period
ORDER BY Time_period;


Time_period
Seattle
Irving
Mini_chih
kettle


2022-01
2
2
1
1

2022-02
0
2
1
1