SQL query to discover records in a population with anomalous history lengths

[refset]

Inspired by something @Akeboshiwind just shared with me, I thought this is a pretty neat query and worth noting down somewhere:

FROM docs FOR valid_time ALL
SELECT _id, COUNT(*) AS c
SELECT c, COUNT(*) AS freq
ORDER BY c ASC, freq DESC;

Play