The Southside Softball League coordinator needs a league schedule report that shows the games, teams involved, field assigned and time for each...

1.  The Southside Softball League coordinator needs a league schedule report that shows the games, teams involved, field assigned and time for each scheduled game. Using the diagram below for your reference, write an SQL query that shows the game_id, field_id, start_date_time, end_date_time, and home and away team names. Order the output ascending by start_date_time, then field_id.