GROUP BY with COUNT condition

Question

I have a result set such as:  

  Code      No
   1         *
   1         -
   1         4
   1         
   1

Now i basically want a query that has 2 columns, a count for the total amount and a count for those that dont have numbers.

  Code      No_Number    Total
   1         4             5

Im assuming this needs a group by and a count but how can i do the 2 different counts in a query like this?

This is what i had so far, but i am a bit stuck with the rest of it

 SELECT CODE,NO
 Sum(Case when No IN ('*', '-', '') then 1 else 0 end) as Count

Answer 1

I think you basically just need GROUP BY:

SELECT CODE,
       SUM(Case when No IN ('*', '-', '') then 1 else 0 end) as Count,
       COUNT(*) as total
FROM t
GROUP BY CODE;