PostgreSQL JSONB query #8 — PostgreSQL

Problem

PostgreSQL: PostgreSQL JSONB query #8

Hints

Ready — edit the code above and click Run.

-- JSONB column example
SELECT data->>'city' AS city
FROM profiles
WHERE data @> '{"active": true}'::jsonb;

Try solving on your own first, then reveal the official answer.

PostgreSQL: CTEs, window functions, ILIKE, JSONB @>, EXPLAIN ANALYZE.