Query: hackernews_jobs_by_technology

select
  case
    when title ~* '\sjavaScript\s'
    or text ~* '\sjavaScript\s' then 'JavaScript'
    when title ~* 'android'
    or text ~* 'android' then 'Android'
    when title ~* 'java'
    or text ~* 'java' then 'Java'
    when title ~* 'kubernetes'
    or title ~* 'K8s'
    or text ~* 'kubernetes'
    or text ~* 'K8s' then 'Kubernetes'
    when title ~* 'php'
    or text ~* 'php' then 'PHP'
    when title ~* 'python'
    or text ~* 'python' then 'Python'
    when title ~* 'react'
    or text ~* 'react' then 'React'
    when title ~* 'rust'
    or text ~* 'rust' then 'Rust'
    when title ~* 'sql'
    or text ~* 'sql' then 'SQL'
    else 'Other'
  end as job_technology,
  count(*)
from
  hackernews_job
group by
  job_technology