Difference between revisions of "Workdocumentation 2022-08-15"

From BITPlan ceur-ws Wiki
Jump to navigation Jump to search
(Created page with "sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki == SubmittedByGt6 == === query === <source lang='sql'> SELECT count(*) as count,submittedBy FROM "volumes"...")
 
Line 23: Line 23:
 
| align="right"|      18 || Pavel Shvaiko
 
| align="right"|      18 || Pavel Shvaiko
 
|-
 
|-
| align="right"|      15 || Philipp Mayr
+
| align="right"|      15 || {{Link|target=Philipp Mayr}}
 
|-
 
|-
 
| align="right"|      13 || Denis Kudryashov
 
| align="right"|      13 || Denis Kudryashov

Revision as of 08:19, 15 August 2022

sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki

SubmittedByGt6

query

SELECT count(*) as count,submittedBy
FROM "volumes"
GROUP BY submittedBY
HAVING COUNT(*) > 6
ORDER BY 1 DESC


result

count submittedBy
26 Nicola Ferro
18 Pavel Shvaiko
15 Philipp Mayr
13 Denis Kudryashov
13 Christoph Lange
10 Sarven Capadisli
10 Pasquale Lops
9 Ruben Verborgh
9 Grzegorz J. Nalepa
9 Christian Napoli
8 Xavier Franch
8 Serhiy O. Semerikov
8 Ralf Klamma
8 Oliver Kutz
8 Horst Lichter
8 Frans Van Assche
8 Dmitry Ustalov
8 Dmitry Ignatov
8 Birgit Penzenstadler
8 Antonio Lieto
8 Adrian Giurca
7 Zoran Budimac
7 Vitaliy Yakovyna
7 Thomas Daniel Ullmann
7 Tarek R. Besold
7 Solomiia Fedushko
7 Sören Auer
7 Paul Johannesson
7 Parth Mehta
7 Max L. Wilson
7 Manuel Wimmer
7 Kostas Stefanidis
7 Kathryn Blackmond Laskey
7 Giuseppe Vizzari
7 Filippo Palumbo
7 Dmitry S. Kulyabov
7 Dietmar Jannach