Skip to content

Instantly share code, notes, and snippets.

@buckmaxwell

buckmaxwell/get_jobs_with_changed_job_scores.sql

Created December 8, 2021 16:19
Show Gist options
  • Save buckmaxwell/2c4cef11fe5294277823b97677b8925b to your computer and use it in GitHub Desktop.
Save buckmaxwell/2c4cef11fe5294277823b97677b8925b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_jobs_with_changed_job_scores.sql
SELECT
l
FROM (
SELECT
jsonb_agg(score ORDER BY added_at) l
FROM
sitter_jobscorehistory
GROUP BY
ongoing_request_id) tab1
WHERE
jsonb_array_length(l) > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment