summaryrefslogtreecommitdiff
path: root/graphs/sql/socially_unfit/req05.sql
diff options
context:
space:
mode:
Diffstat (limited to 'graphs/sql/socially_unfit/req05.sql')
-rw-r--r--graphs/sql/socially_unfit/req05.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/graphs/sql/socially_unfit/req05.sql b/graphs/sql/socially_unfit/req05.sql
new file mode 100644
index 0000000..45029d8
--- /dev/null
+++ b/graphs/sql/socially_unfit/req05.sql
@@ -0,0 +1,5 @@
+SELECT id,person_id,credits_change,action_description
+FROM public.social_credit_history
+WHERE date >= '2059-12-03 17:00' AND date <= '2059-12-03 22:00'
+ORDER BY credits_change,id
+LIMIT 10