SQLite 3.39

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

CREATE TABLE "order" (id int primary key, customer_id int null);
✓
INSERT INTO "order" (id, customer_id) VALUES (1, NULL);
✓
SELECT id, COUNT(DISTINCT customer_id) FROM "order" GROUP BY "order"."id"


id
COUNT(DISTINCT customer_id)


1
0