code: def reducing_join_statement() -> SqlSelectStatementNode:
      """SELECT statement used to build test cases.
  
      -- query
      SELECT
        src2.bookings AS bookings
        , src3.listings AS listings
      FROM (
        -- src2
        SELECT
          SUM(src1.bookings) AS bookings
        FROM (
          -- src1
          SELECT
            1 AS bookings
          FROM demo.fct_bookings src0
        ) src1
      ) src2
      CROSS JOIN (
        -- src4
        SELECT
          SUM(src4.listings) AS listings
        FROM demo.fct_listings src4
      ) src3
      """
      return SqlSelectStatementNode(
          description="query",
          select_columns=(
              SqlSelectColumn(
                  expr=SqlColumnReferenceExpression(
                      col_ref=SqlColumnReference(
                          table_alias="src2", column_name="bookings"
                      )
                  ),
                  column_alias="bookings",
              ),
              SqlSelectColumn(
                  expr=SqlColumnReferenceExpression(
                      col_ref=SqlColumnReference(
                          table_alias="src3", column_name="listings"
                      )
                  ),
                  column_alias="listings",
              ),
          ),
          from_source=SqlSelectStatementNode(
              description="src2",
              select_columns=(
                  SqlSelectColumn(
                      expr=SqlAggregateFunctionExpression(
                          sql_function=SqlFunction.SUM,
                          sql_function_args=[
                              SqlColumnReferenceExpression(
                                  col_ref=SqlColumnReference(
                                      table_alias="src1",
                                      column_name="bookings",
                                  )
                              )
                          ],
                      ),
                      column_alias="bookings",
                  ),
              ),
              from_source=SqlSelectStatementNode(
                  description="src1",
                  select_columns=(
                      SqlSelectColumn(
                          expr=SqlStringExpression(
                              sql_expr="1",
                              requires_parenthesis=False,
                              used_columns=(),
                          ),
                          column_alias="bookings",
                      ),
                  ),
                  from_source=SqlTableFromClauseNode(
                      sql_table=SqlTable(
                          schema_name="demo", table_name="fct_bookings"
                      )
                  ),
                  from_source_alias="src0",
                  joins_descs=(),
                  where=None,
                  group_bys=(),
                  order_bys=(),
                  limit=None,
              ),
              from_source_alias="src1",
              joins_descs=(),
              where=None,
              group_bys=(),
              order_bys=(),
              limit=None,
          ),
          from_source_alias="src2",
          joins_descs=(
              SqlJoinDescription(
                  right_source=SqlSelectStatementNode(
                      description="src4",
                      select_columns=(
                          SqlSelectColumn(
                              expr=SqlAggregateFunctionExpression(
                                  sql_function=SqlFunction.SUM,
                                  sql_function_args=[
                                      SqlColumnReferenceExpression(
                                          col_ref=SqlColumnReference(
                                              table_alias="src4",
                                              column_name="listings",
                                          )
                                      )
                                  ],
                              ),
                              column_alias="listings",
                          ),
                      ),
                      from_source=SqlTableFromClauseNode(
                          sql_table=SqlTable(
                              schema_name="demo",
                              table_name="fct_listings",
                          )
                      ),
                      from_source_alias="src4",
                      joins_descs=(),
                      where=None,
                      group_bys=(),
                      order_bys=(),
                      limit=None,
                  ),
                  right_source_alias="src3",
                  on_condition=None,
                  join_type=SqlJoinType.CROSS_JOIN,
              ),
          ),
          group_bys=(),
          where=None,
          order_bys=(),
          limit=None,
      )
  
imports: from __future__ import annotations
  import pytest
  from _pytest.fixtures import FixtureRequest
  from metricflow.dataflow.sql_table import SqlTable
  from metricflow.sql.optimizer.rewriting_sub_query_reducer import SqlRewritingSubQueryReducer
  from metricflow.sql.sql_exprs import SqlAggregateFunctionExpression, SqlColumnReference, SqlColumnReferenceExpression, SqlComparison, SqlComparisonExpression, SqlFunction, SqlStringExpression, SqlStringLiteralExpression
  from metricflow.sql.sql_plan import SqlJoinDescription, SqlJoinType, SqlOrderByDescription, SqlSelectColumn, SqlSelectStatementNode, SqlTableFromClauseNode
  from metricflow.test.fixtures.setup_fixtures import MetricFlowTestSessionState
  from metricflow.test.sql.compare_sql_plan import assert_default_rendered_sql_equal
label_desc: Use image node_id 9 for calling a global function with example usage: reducing_join_statement() and returns: SqlSelectStatementNode