Trying to select the latest of visit of a customer

const customerSchema = v.object({
    id: idWithDefaultSchema,
    first_name: v.pipe(v.string(), v.minLength(3)),
    last_name: v.nullish(v.pipe(v.string(), v.minLength(3))),
    phone_number: v.nullish(phoneNumberSchema),
    organization_id: v.string(),
});

const visitSchema = v.object({
    id: idWithDefaultSchema,
    date: v.date(),
    customer_id: idSchema,
    status: visitStatusTypeSchema,
});

const visitServiceSchema = v.object({
    id: idWithDefaultSchema,
    service_organization_id: idSchema,
    custom_service: v.nullish(v.string()),
    payment: v.nullish(v.number()),
    duration: v.nullish(v.string()),
    customer_visit_id: idSchema,
});

const customerSchema = v.object({
    id: idWithDefaultSchema,
    first_name: v.pipe(v.string(), v.minLength(3)),
    last_name: v.nullish(v.pipe(v.string(), v.minLength(3))),
    phone_number: v.nullish(phoneNumberSchema),
    organization_id: v.string(),
});

const visitSchema = v.object({
    id: idWithDefaultSchema,
    date: v.date(),
    customer_id: idSchema,
    status: visitStatusTypeSchema,
});

const visitServiceSchema = v.object({
    id: idWithDefaultSchema,
    service_organization_id: idSchema,
    custom_service: v.nullish(v.string()),
    payment: v.nullish(v.number()),
    duration: v.nullish(v.string()),
    customer_visit_id: idSchema,
});