written Query to this scnario

Question

Hello DBExpert,

 

--input--

state city

AP hyderabad

AP thirupathi

AP vijag

KT bangalore

KT mysure

TN chennai

TN coembattore 

 

--output--

state city

AP     hyderabad,thirupathi,vijag

KT     bangalore,mysure

TN    chennai,coembattore

 

how can i write the Query to output in sql server