def METHOD_NAME(snapshot):
    context = ImpalaCompiler.make_context()
    table1 = ibis.table([("key1", "string"), ("value1", "double")])
    table2 = ibis.table([("key2", "string"), ("value and2", "double")])
    context.set_ref(table1.op(), "t0")
    context.set_ref(table2.op(), "t1")
    expr = table1["value1"] - table2["value and2"]
    result = translate(expr, context=context)
    snapshot.assert_match(result, "out.sql")