5 lines
192 B
SQL
5 lines
192 B
SQL
SELECT
|
|
COUNT(*) AS "All",
|
|
COUNT(CASE WHEN URL ~ '://[^:]+:[0-9]+' THEN 1 END) AS "With port",
|
|
COUNT(CASE WHEN URL !~ '://[^:]+:[0-9]+' THEN 1 END) AS "Without port"
|
|
FROM snapshots; |