Difference between revisions of "What are the 10 most common surnames of soccer players? (Q439)"

@@ label / en / label / en @@
+What are the 10 most common surnames of soccer players?
@@ aliases / es / 0 / aliases / es / 0 @@
+¿Cuáles son los 10 apellidos más frecuentes de futbolistas?
@@ aliases / en / 0 / aliases / en / 0 @@
+What are the 10 most common family names of football players?
@@ Property / query / Property / query @@
-SELECT ?surname WHERE { { SELECT ?surname (COUNT(?person) AS ?count) WHERE { ?person wdt:P106 wd:Q937857. ?person wdt:P734 ?surname. } GROUP BY ?surname } } ORDER BY DESC(?count) LIMIT 10
+SELECT ?surname WHERE { ?person wdt:P106 wd:Q937857. ?person wdt:P734 ?surname. } GROUP BY ?surname ORDER BY DESC(COUNT(DISTINCT ?person)) LIMIT 10
+dataset: Wikidata
+query language: SPARQL
@@ Property / mention @@
-occupation (English)
@@ Property / mention: occupation (English) / rank @@
-Normal rank
@@ Property / mention: occupation (English) / qualifier @@
-Wikidata item ID: P106
@@ Property / mention @@
+family names (English)
@@ Property / mention: family names (English) / rank @@
+Normal rank
@@ Property / mention: family names (English) / qualifier @@
+Wikidata property ID: P734
@@ Property / mention: family names (English) / qualifier @@
+Wikidata item ID: Q101352
@@ Property / mention @@
+apellidos (Spanish)
@@ Property / mention: apellidos (Spanish) / rank @@
+Normal rank
@@ Property / mention: apellidos (Spanish) / qualifier @@
+Wikidata property ID: P734
@@ Property / mention: apellidos (Spanish) / qualifier @@
+Wikidata item ID: Q101352
@@ Property / mention @@
+surnames (English)
@@ Property / mention: surnames (English) / rank @@
+Normal rank
@@ Property / mention: surnames (English) / qualifier @@
+Wikidata property ID: P734
@@ Property / mention: surnames (English) / qualifier @@
+Wikidata item ID: Q101352
@@ Property / mention @@
+names (English)
@@ Property / mention: names (English) / rank @@
+Normal rank
@@ Property / mention: names (English) / qualifier @@
+Wikidata item ID: Q82799
@@ Property / imports mentions from @@
+How many football players have the family name Suazo?
+Normal rank

Difference between revisions of "What are the 10 most common surnames of soccer players? (Q439)"

Latest revision as of 23:41, 18 May 2025

Statements

Navigation menu

Search