RE: The Nigeria List: June 2024

[alex-rourke]

Nice!

5 dolphins and 2 Orcas. I'd like to say hi. Any chance you could tell me who they are? I don't know how to use HiveSQL (yet).

Comments

[steevc]

Here you go:

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