This query might seem simple, but it can lead to unexpected results if the `salary` column contains NULL values. The condition `salary > 100000` will evaluate to `UNKNOWN` for NULL salaries, and ...
I get an ambiguous column error for: user_id. query = """ SELECT table_1.user_id, table_1.method_id, FROM table_1 LEFT JOIN table_2 ON table_2.user_id = table_1.user ...