def METHOD_NAME(self):
    """Check order by with expression.
    """
    expected = convert_output("""
              avg
    ------------------------
     0
     0
     0
     1
     1
     1
     1
     2
     3
     3
    """)
    execute_query(
        "SELECT avg(four) OVER (PARTITION BY four ORDER BY thousand / 100) AS avg FROM tenk1 WHERE unique2 < 10",
        expected=expected,
    )