3 lines
297 B
SQL
3 lines
297 B
SQL
SELECT CertificateIssuerCountry, COUNT(*) c FROM Filtered GROUP BY CertificateIssuerCountry HAVING c > 1 ORDER BY c DESC;
|
|
|
|
--SELECT ServerType1, ServerType2 FROM Filtered WHERE (ServerType1 NOT NULL AND ServerType1 != '') AND (ServerType2 NOT NULL AND ServerType2 != '') ORDER BY ServerType2 DESC; |