Query: project_other_license_count

select
  'Other' as label,
  count(*) as value
from
  gitlab_my_project
where
  license_key is not null
  and license_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'
  );