how can you add a where to the above.

So it only counts fields for value x in field a.

select count(total) from tblt where tblt.name = 'name'