From 274da5d3994e9f1a4ddabf2d3ddba06c5db1aa73 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
Date: Wed, 1 Jul 2020 16:34:13 -0700
Subject: commit example of an elasticsearch SQL query

---
 extra/elasticsearch/sql_queries.md | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 extra/elasticsearch/sql_queries.md

diff --git a/extra/elasticsearch/sql_queries.md b/extra/elasticsearch/sql_queries.md
new file mode 100644
index 00000000..3ea168e5
--- /dev/null
+++ b/extra/elasticsearch/sql_queries.md
@@ -0,0 +1,8 @@
+
+Top missing OA journals by `container_id`:
+
+    POST _xpack/sql?format=txt
+    {
+    "query": "SELECT container_id, count(*) from fatcat_release WHERE preservation = 'none' AND is_oa = true GROUP BY container_id ORDER BY count(*) DESC LIMIT 20"
+    }
+
-- 
cgit v1.2.3