SQL count show group by show in column instead of rows

I have a table like this

Now my output would like to be

total_rows | completed | incomplete
------------------------------------
7              2            5

How can I achieve that.

Answer

You could use condition aggregation

select count(*) total ,
      sum(completed = 1) completed , 
      sum(completed = 0) incompleted 
from your_table