By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE orders(
id INTEGER NOT NULL PRIMARY KEY
,memberid INTEGER NOT NULL
,deliverydate DATE NOT NULL
);
INSERT INTO orders(id,memberid,deliverydate) VALUES (1,991,'2019-10-25');
INSERT INTO orders(id,memberid,deliverydate) VALUES (2,991,'2019-10-26');
INSERT INTO orders(id,memberid,deliverydate) VALUES (3,992,'2019-10-25');
INSERT INTO orders(id,memberid,deliverydate) VALUES (4,992,'2019-10-25');
INSERT INTO orders(id,memberid,deliverydate) VALUES (5,993,'2019-10-24');
INSERT INTO orders(id,memberid,deliverydate) VALUES (7,994,'2019-10-21');
INSERT INTO orders(id,memberid,deliverydate) VALUES (6,994,'2019-10-26');
INSERT INTO orders(id,memberid,deliverydate) VALUES (8,995,'2019-10-26');
select first_deliverydate, count(*) cnt
from (
select min(deliverydate) first_deliverydate
from orders
group by memberid
) t
group by first_deliverydate
order by first_deliverydate
| first_deliverydate | cnt |
|---|---|
| 2019-10-21 | 1 |
| 2019-10-24 | 1 |
| 2019-10-25 | 2 |
| 2019-10-26 | 1 |