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