So:
SELECT COUNT(*) AS QTD FROM AtivacaoGuincho
WHERE DataFim is null
Since Marlon has touched on the subject of line counting, I can
little more this response and get into a subject that is almost a curiosity.
The count is basically used in this way. I ask you to count all rows where DATAFIM is null.
But could do so:
SELECT COUNT(*) AS TOTAL, COUNT(DATAFIM) AS DTFIM FROM AtivacaoGuincho
And it would have something like this: I have 1884 rows in the table and 50 rows where DATAFIM is null.
Of course, I could have as many counts as I wanted in my select.