[chronojump] Added countPingsAtServer.txt

[Xavier de Blas <xaviblas src gnome org>]

commit a7a8ce1748e61842f05df1977768151a78c6bd56
Author: Xavier de Blas <xaviblas gmail com>
Date:   Sat Jan 23 13:46:24 2021 +0100

    Added countPingsAtServer.txt

 testing-stuff/countPingsAtServer.txt | 13 +++++++++++++
 1 file changed, 13 insertions(+)
---
diff --git a/testing-stuff/countPingsAtServer.txt b/testing-stuff/countPingsAtServer.txt
new file mode 100644
index 00000000..cad77eda
--- /dev/null
+++ b/testing-stuff/countPingsAtServer.txt
@@ -0,0 +1,13 @@
+Different Chronojump installations of a version by operating system
+
+SELECT COUNT(DISTINCT machineID), substring(osVersion, 1,6) AS osv FROM ping WHERE cjVersion LIKE "%2.0.2%" 
GROUP BY osv;
+
+or:
+
+SELECT COUNT(DISTINCT machineID), osVersion FROM ping WHERE cjVersion LIKE "%2.0.2%" GROUP BY osVersion;
+
+or:
+
+SELECT COUNT(*) FROM ping WHERE cjVersion LIKE "%2.0.2%" AND osVersion LIKE "%MacOSX%" GROUP BY machineID;
+SELECT COUNT(*) FROM ping WHERE cjVersion LIKE "%2.0.2%" AND osVersion LIKE "Unix, %" GROUP BY machineID;
+SELECT COUNT(*) FROM ping WHERE cjVersion LIKE "%2.0.2%" AND osVersion LIKE "%Win%" GROUP BY machineID;