I have a table called stock.It have columns named as `item_id`, `'qty'` and `'branch_id'`.
what i need do is select item ids which the sum of 'qty' column grater than zero and branch\_id equal to 4.

I have try with this query but I need only to view `item_id column`. This prints `total` column too.

```
SELECT `item_id`, SUM(`qty`) as total from `stock` 
group by `item_id` HAVING total > 0 and where branch_id = 4 

```

help please.