Sub query question.

Question

I Need to select total number of banks each from different cities from thr same table with banks indicated as 1 for yes n null for no. Thus it will be a sub query.

Answer 1

Try:
select city, count(*)
from table_name
where is_bank=1
group by city;
or something like that, this should return num of banks per city, hope I understood the question...