Queries

Query examples

Real questions answered in SQL. Each page shows the query itself, the sources it reads, and how to check what comes back.

Runnable patterns

Trace a phrase on Hacker News with SQL A Scry query pattern for tracing a public phrase through Hacker News by month, distinct authors, and inspectable source rows.Find the first use of a phrase on Reddit with SQL A Scry query pattern for locating the earliest occurrences of a phrase in a subreddit, with author, timestamp, score, and the full comment row attached.Recover a prediction market's full price path with SQL A Scry query pattern for reconstructing a Manifold market's probability history bet by bet, from the per-bet prob_before and prob_after fields.Chart a community's drift along a meaning axis with SQL A Scry query pattern that mints two poles as vectors, takes the balanced axis between them, and averages every LessWrong post's projection quarter by quarter.