PostgreSQL JSONB Query

1SELECT
2  id,
3  data->>'name' AS name,
4  data->'address'->>'city' AS city
5FROM
6  users
7WHERE
8  data @> '{"active": true}'
9  AND data->'tags' ? 'premium'
10ORDER BY
11  data->>'created_at' DESC
12LIMIT 10;