WITH dataset AS (SELECT * FROM (VALUES
(JSON '{"name": "Bob Smith", "org": "legal"}'),
(JSON '{"name": "Susan Smith", "org": "engineering"}'),
(JSON '{"name": "Jane Smith", "org": "finance"}')
) AS t (users)
)
SELECT json_extract_scalar(users, '$.name') AS user
FROM dataset
我希望在此查询中使用如下条件 Where‘org’=‘Legal’我如何才能做到这一点?