SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE GameAssignment
    ([ID] int IDENTITY(1,1) PRIMARY KEY, [GameId] int, [OfficialId] int, [Position] int)
;

INSERT INTO GameAssignment
    ([GameId], [OfficialId], [Position])
VALUES
    ('1', '1', '1'),
    ('1', '2', '1'),
    ('2', '1', '1'),
    ('2', '2', '2'),
    ('3', '1', '1'),
    ('3', '2', '2'),
    ('3', '3', '3')
;

CREATE TABLE FieldGym
    ([ID] int IDENTITY(1,1) PRIMARY KEY, [FieldGym] varchar(50))
;

INSERT INTO FieldGym
    ([FieldGym])
VALUES
    ('U6 Field 1'),
    ('U6 Field 2'),
    ('U8 Field 1')
;

CREATE TABLE Official
    ([ID] int IDENTITY(1,1) PRIMARY KEY, [cFName] varchar(50), [cLName] varchar(50))
;

INSERT INTO Official
    ([cFName], [cLName])
VALUES
    ('Joe', 'Blow'),
    ('Billy', 'Joel'),
    ('Chris', 'Farley')
;

CREATE TABLE Games
    ([ID] int IDENTITY(1,1) PRIMARY KEY, [DateTime] datetime, [FieldGym] int)
;

INSERT INTO Games
    ([DateTime], [FieldGym])
VALUES
    ('09/04/2021 8:00:00', '1'),
    ('09/04/2021 8:00:00', '2'),
    ('09/04/2021 8:00:00', '3'),
    ('09/04/2021 9:00:00', '1'),
    ('09/04/2021 9:00:00', '2'),
    ('09/04/2021 9:00:00', '3'),
    ('09/04/2021 10:00:00', '1'),
    ('09/04/2021 11:00:00', '1'),
    ('09/04/2021 10:00:00', '2')
;

22 rows affected

id	DateTime	Ref
3	Sep 4 2021 8:00:00:000AM	Billy Joel
		Chris Farley
		Joe Blow