Read only zero values ​​in two different columns and show select in one clause

Question

I want to count only the null values ​​in a certain column and all the null values ​​in another, but I want my result to have both of these results shown in the same table.

Here is what I still have:

Select Count(*) as 'Column1Count', Count(*) as 'Column2Count'
   from table1
       Where column1 is null
     and column2 is null

please, help

Answer 1

This should work:

select
    (select count(*) from table1 where column1 is null) as 'Column1Count',
    (select count(*) from table1 where column2 is null) as 'Column2Count';

Answer 2

You can use the case for this:

select  sum(case when Column1 is null then 1 end) as Col1Count
,       sum(case when Column2 is null then 1 end) as Col2Count
from    table1