Query: repository_permissive_license_count

select
  'Permissive' as label,
  count(*) as value
from
  github_my_repository
where
  license_info ->> 'key' in (
    'apache-2.0',
    'mit',
    'bsd-3',
    'bsd-2',
    'bsd-3-clause',
    'bsd2-clause',
    'cc-by-4.0',
    'wtfpl',
    'ms-pl',
    'unlicensed'
  )
group by
  license_info;