Query: repository_license_table

select
  name_with_owner as "Repository",
  license_info ->> 'key' as "License",
  license_info ->> 'name' as "License Name",
  case
    when (license_info ->> '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_info ->> '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_info ->> '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_info ->> 'key' is null) then null
    else 'other'
  end as "License Type",
  url
from
  github_my_repository
order by
  "License";