Query: repository_popular_copyleft_license_count

select
  'Popular Copyleft' as label,
  count(*) as value
from
  github_my_repository
where
  license_info ->> 'key' in (
    'gpl-3.0',
    'gpl-2.0',
    'agpl-3.0',
    'agpl-2.0',
    'cc-by-sa-4.0',
    'apsl'
  )
group by
  license_info;