Query: hackernews_jobs_search

select
  id as "ID",
  by as "By",
  to_char(time::timestamptz, 'YYYY-MM-DD') as "Time",
  score as "Score",
  title as "Title",
  case
    when url = '<null>' then ''
    else url
  end as "URL"
  -- TODO: Cleanup HTML in text before re-adding
  --text as "Text"
from
  hackernews_job
order by
  time desc,
  score desc;