CREATE TABLE [dbo].[test1]
             ([Город] VARCHAR(255) NOT NULL 
            , GG1     INT NOT NULL
            , GG2     INT NOT NULL
            , GG3     INT NOT NULL
            , G1      INT NOT NULL
            , G2      INT NOT NULL
            , G3      INT NOT NULL
             );

GO

INSERT INTO [dbo].[test1]([Город], GG1, G1, GG2, G2, GG3, G3)
SELECT 'Город 1', 1, 2, 3, 4, 5, 6 UNION ALL 
SELECT 'Город 2', 1, 2, 3, 4, 5, 6 UNION ALL 
SELECT 'Город 3', 1, 2, 3, 4, 5, 6 UNION ALL 
SELECT 'Город 4', 1, 2, 3, 4, 5, 6 UNION ALL 
SELECT 'Город 5', 1, 2, 3, 4, 5, 6 
GO
 
DECLARE @object_id INT           = OBJECT_ID('[dbo].[test1]')
      , @sql       VARCHAR(1000);

SELECT 
       @sql = 'SELECT [Город]'+
                               (
                                SELECT 
                                       ', '+QUOTENAME(c.[name])
                                FROM 
                                     sys.columns AS c
                                WHERE c.object_id = @object_id
                                      AND c.[name] LIKE 'GG%' FOR
                                XML PATH('')
       )+' FROM '+QUOTENAME(OBJECT_SCHEMA_NAME(@object_id))+'.'+QUOTENAME(OBJECT_NAME(@object_id));

EXECUTE (@sql);
GO 

DROP TABLE [dbo].[test1];