Count number of nodes with a particular term id for Drupal 8.x

term-node-count.sql

select
  ti.tid
  , ttfd.name
  , count(1) as count 
from
  taxonomy_index ti join node n on n.nid = ti.nid
  , taxonomy_term_data td
  , taxonomy_term_field_data ttfd 
where
  td.tid = ti.tid 
  and td.vid = 'tags'
  and ttfd.tid = ti.tid 
group by 
  ti.tid, ttfd.name 
order by 
  count desc 
limit 500