Query: repository_other_license_count

select
  'Other' as label,
  count(*) as value
from
  github_my_repository
where
  license_info is not null
  and license_info ->> 'key' not in (
    'lgpl-3.0',
    'lgpl-2.1',
    'mpl-2.0',
    'epl-2.0',
    'osl-3.0',
    'eupl-1.2',
    'gpl-3.0',
    'gpl-2.0',
    'agpl-3.0',
    'agpl-2.0',
    'cc-by-sa-4.0',
    'apsl',
    '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;