Report question

Question: SQL for total count and count within that where condition is true