SELECT
 COUNT(*) AS count,
 AVG(query_time) AS avgQueryTime,
 reflect("java.net.URLEncoder", "encode",query) AS urlEncodedQuery
FROM event.wdqs_external_sparql_query
WHERE year = 2020
 AND month = 07
 AND day = 22
 AND namespace = "wdq"
GROUP BY query
ORDER BY count DESC
LIMIT 1000000

SELECT
 COUNT(*) AS count,
 AVG(query_time) AS avgQueryTime,
 reflect("java.net.URLEncoder", "encode",query) AS urlEncodedQuery
FROM event.wdqs_external_sparql_query
WHERE year = 2020
 AND month = 07
 AND day = 22
 AND namespace = "wdq"
GROUP BY query
ORDER BY avgQueryTime DESC
LIMIT 1000000