You are viewing a single comment's thread from:

RE: The Nigeria List: June 2024

in Hive Statistics6 months ago (edited)

Here you go:

image.png

This is the query:

select a.name, a.vesting_shares, a.last_vote_time
from accounts a
where a.posting_json_metadata like '%"location":%' and
(JSON_VALUE(posting_json_metadata,'$.profile.location') like '%nigeria%'
or JSON_VALUE(posting_json_metadata,'$.profile.location') like '%lagos%'
or JSON_VALUE(posting_json_metadata,'$.profile.location') like '%abuja%')
and vesting_shares > 10000000
order by vesting_shares