Query: project_without_license_count

select
  'Without License' as label,
  count(*) as value,
  case
    when count(*) > 0 then 'alert'
    else 'ok'
  end as type
from
  gitlab_my_project
where
  license_key is null
  or license_key = '';