WolfgangFahl
commented
3 years ago see also #146
Open WolfgangFahl opened 3 years ago
WolfgangFahl
commented
3 years ago see also #146
tholzheim
commented
2 years ago Issue 228 countries occurring once
query
SELECT ROW_NUMBER() OVER(ORDER BY country) AS "#", country, url
FROM event_orclonebackup
WHERE country IN
(SELECT country
FROM(
SELECT COUNT(*) AS commonness, country
FROM event_orclonebackup
GROUP BY country
ORDER BY commonness DESC) AS cc
WHERE commonness == 1)Query res is reduced to the country names not identified as countries
see https://rq.bitplan.com/index.php/Workdocumentation_2021-05-10