请尝试以下操作:

SELECT max(c.ts) as ts, c.age FROM c where c.age in (20, 30, 40) 
Group By c.age

这将提供以下输出:

[
    {
        "ts": "00:02",
        "age": 40
    },
    {
        "ts": "00:01",
        "age": 30
    },
    {
        "ts": "00:01",
        "age": 20
    }
]