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