MINIFS to SQL MIN with WHERE

Earliest shipped date per customer is MIN(order_date) with a filter, grouped.

SELECT MIN(order_date) FROM Orders WHERE status = 'Shipped';
SELECT customer_id, MIN(CASE WHEN status = 'Shipped' THEN order_date END)
FROM Orders
GROUP BY customer_id;

MIN ignores NULL, so a CASE that returns NULL on the miss is safe.

Canonical translation

SELECT MIN(order_date) FROM Orders WHERE status = 'Shipped';
SELECT customer_id, MIN(CASE WHEN status = 'Shipped' THEN order_date END)
FROM Orders
GROUP BY customer_id;