help with complex query

use this

select SUM(Case When status = 0 THEN 1 ELSE 0 END), sum(Case When status = 0 And Weigh Is Not Null Then 1 Else 0 End) As CountStatus0