Query: project_license_table

select
  full_path as "Project",
  license_key as "License",
  license as "License Name",
  case
    when (license_key in ('lgpl-3.0','lgpl-2.1','mpl-2.0','epl-2.0','osl-3.0','eupl-1.2')) then 'weak copyleft'
    when (license_key in ('gpl-3.0','gpl-2.0','agpl-3.0','agpl-2.0','cc-by-sa-4.0','apsl')) then 'popular copyleft'
    when (license_key in ('apache-2.0','mit','bsd-3','bsd-2','bsd-3-clause','bsd2-clause', 'cc-by-4.0', 'wtfpl', 'ms-pl', 'unlicensed')) then 'permissive'
    when (license_key is null) then null
    else 'other'
  end as "License Type",
  web_url,
  license_url
from
  gitlab_my_project;