CREATE TABLE #t(province nvarchar(10),city nvarchar(10),score int) 
insert into #t values('陕西','西安',3 )
insert into #t values('陕西','安康',4 )
insert into #t values('陕西','汉中',2 )
insert into #t values('广东','广州',5 )
insert into #t values('广东','珠海',2 )
insert into #t values ...