Pandas query to SQL WHERE

query is a WHERE you typed as a string. SQL is that string, with = not ==.

SELECT * FROM Orders
WHERE status = 'Shipped' AND total_amount > 50;

in ["A","B"] is IN ('A', 'B'). not in is NOT IN, watching NULLs.

Canonical translation

SELECT * FROM Orders
WHERE status = 'Shipped' AND total_amount > 50;