1 files changed, 7 insertions, 0 deletions
diff --git a/catquery.py b/catquery.py
index 7b3bc5c..12921c4 100644
--- a/catquery.py
+++ b/catquery.py
@@ -14,3 +14,10 @@ QUERY_INSERT_EVENT = \
 INSERT INTO events(type, remarks, correspond) VALUES (?,?,?)
 
 """
+
+QUERY_COUNT_INTERACTION = \
+"""
+SELECT correspond, count(correspond)
+  FROM events
+ GROUP by correspond
+"""