select inside select how do we do

i have once done somthing like this i don`t remember how i did it

table names

fields names,city

i want to display the name and how many times the name is there and to which city the name belongs to



select name,select count(name) from names group by names,city, from names

 

Plz try

select name,city, count(name) as total from names group by city;

 

thanx for u r help it was nice to be under your guidance