Querys-for-Mongo-and-Postgres-OLAP-bench.md

+## This querys were extracted from AHT blog https://www.8kdata.com/blog/announcing-torodb-stampede-1-0-beta/ for run in our test and modify if necessary.
+
+
+## PostgreSQL
+### Stampede-GithuQuery-PostgreSQL-A 
+```
+SELECT		repo.name_s, count(*)
+FROM 		github.events AS events 
+        		INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
+        		INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
+WHERE		events.type_s = 'IssuesEvent' AND payload.action_s = 'opened'
+GROUP BY	repo.name_s
+ORDER BY	count desc;
+```
+### Stampede-GithuQuery-PostgreSQL-B
+```
+SELECT		type_s, count(*)
+FROM		github.events
+GROUP BY	type_s 
+ORDER BY	count desc;
+```
+### Stampede-GithuQuery-PostgreSQL-C
+```
+SELECT		events.type_s, count(*) 
+FROM		github.events AS events 
+        	JOIN github.events_actor AS actor ON (events.did = actor.did)
+GROUP BY	type_s 
+ORDER BY	count DESC;
+```
+### Stampede-GithuQuery-PostgreSQL-D
+```
+SELECT		action_s, count(*)
+FROM		github.events_payload
+WHERE 		action_s IS NOT NULL
+GROUP BY	action_s
+ORDER BY	count DESC;
+```
+### Stampede-GithuQuery-PostgreSQL-E
+```
+WITH distinct_commits AS (
+        SELECT	DISTINCT repo.name_s, actor.login_s
+        FROM	github.events AS events 
+                INNER JOIN github.events_actor AS actor ON (events.did = actor.did)
+                INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
+        WHERE	events.type_s = 'PushEvent' 
+)
+SELECT		name_s, count(*) 
+FROM		distinct_commits
+GROUP BY	name_s
+ORDER BY	count DESC;
+```
+### Stampede-GithuQuery-PostgreSQL-F
+```
+SELECT		repo.name_s, avg(payload.size_i)
+FROM		github.events AS events 
+        		INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
+        		INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
+WHERE		events.type_s = 'PushEvent' AND payload.size_i > 2
+GROUP BY	repo.name_s
+ORDER BY 	avg DESC;
+```
\ No newline at end of file