framework/resources/Functional/joins/join/jn_using_43.q

SELECT AVG(r.col_prime) FROM using_f1 l JOIN using_f2 r USING(col_state);