graphs/sql/socially_unfit/req04.sql


1
2
3
4
5
6

SELECT first_name,last_name,birth_date,job_id,social_credit_balance
FROM public.people
WHERE job_id IS NOT NULL
AND social_credit_balance > 0
AND death_date IS NULL
ORDER BY social_credit_balance DESC,birth_date,job_id LIMIT 100 OFFSET 200