my code:

```
SELECT ROW_NUMBER() OVER(ORDER BY Title ASC) as row, 
       Title, 
       BookNo, 
       COUNT(*) as Copies, 
       COUNT(Status = 1) 
from tbbook 
GROUP BY Title

```

[result i got](https://i.stack.imgur.com/F45PE.png)