SQL Queries Tag Indonesia

Count Total Accounts in Steem :

SELECT COUNT(*) as total_account
from Accounts

---
Count Total Accounts using tag indonesia as main category:

select COUNT(*) as total_account from
(
	select author, COUNT(*) as total_post
	from
	    Comments (NOLOCK)
	where
		depth = 0
		AND category='indonesia'
	group by author
) a

---
Count Total Accounts using tag indonesia:

select COUNT(*) as total_account from
(
	select author, COUNT(*) as total_post
	from
	    Comments (NOLOCK)
	where
		depth = 0
		AND ISJSON(json_metadata) > 0
		AND (JSON_QUERY(json_metadata,'$.tags') like '%"indonesia"%' OR category = 'indonesia')
	group by author
) a

---
Count Total main category in Steem:

select COUNT(*) as total_category from (
	select category, COUNT(*) as total_post
	from
	    Comments (NOLOCK)
	where
		depth = 0
	group by
		category
) a

---
Count Total posts :


select COUNT(*) as total_post
from
    Comments (NOLOCK)
where
	depth = 0

---
Count Total posts using tag Indonesia as main category:

select category, COUNT(*) as total_post
from
    Comments (NOLOCK)
where
	depth = 0
	AND category = 'indonesia'
group by
	category

---
Count Total posts using tag Indonesia :

select COUNT(*) as total_post
from
    Comments (NOLOCK)
where
	depth = 0
	AND ISJSON(json_metadata) > 0
	AND (JSON_QUERY(json_metadata,'$.tags') like '%"indonesia"%' OR category = 'indonesia')