Sql query to calculate sum of rows by 2 columns?

Question

SQL

Greetings!
There is a table with 2 columns, 1 column Port 2 Subscriber
There are empty lines in the second column.
It is required by one SQL query to calculate the sum of rows in column 1 and the sum of rows in column 2, excluding empty rows.

Answer 1

select
 count(port) ports_count,
 count(case when abonent!='' then 1 else null end) abonents_count
from ports

Counts the number of port and abonent strings, excluding null and an empty string for abonent. If null and empty string are the same, then no case is needed.