By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE calendar_items(
calendar_id INTEGER NOT NULL PRIMARY KEY
,order_id INTEGER NOT NULL
,date DATE NOT NULL
);
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (1,1,'2019-11-13');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (2,1,'2019-11-14');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (3,1,'2019-11-15');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (4,2,'2019-11-13');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (5,2,'2019-11-14');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (6,3,'2019-11-16');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (7,3,'2019-11-17');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (8,3,'2019-11-18');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (9,4,'2019-11-13');
INSERT INTO calendar_items(calendar_id,order_id,date) VALUES (10,4,'2019-11-14');
select order_id, max(date) date
from calendar_items c
group by order_id
having max(date) = '2019-11-14'
| order_id | date |
|---|---|
| 2 | 2019-11-14 |
| 4 | 2019-11-14 |