diff options
Diffstat (limited to 'graphs/sql/socially_unfit/req04.sql')
| -rw-r--r-- | graphs/sql/socially_unfit/req04.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/graphs/sql/socially_unfit/req04.sql b/graphs/sql/socially_unfit/req04.sql new file mode 100644 index 0000000..a11948a --- /dev/null +++ b/graphs/sql/socially_unfit/req04.sql @@ -0,0 +1,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 |