added query to fill no_concl_hyp table

[helm.git] / helm / metadata / sql / fill_no_concl_hyp.sql

diff --git a/helm/metadata/sql/fill_no_concl_hyp.sql b/helm/metadata/sql/fill_no_concl_hyp.sql
new file mode 100644 (file)
index 0000000..3294fe1
--- /dev/null
+++ b/helm/metadata/sql/fill_no_concl_hyp.sql
@@ -0,0 +1,7 @@
+
+INSERT INTO no_concl_hyp
+SELECT source, COUNT(DISTINCT h_occurrence)
+FROM refObj
+WHERE NOT (h_position="http://www.cs.unibo.it/helm/schemas/schema-helm#InBody")
+GROUP BY source;
+