Pandas loc to SQL WHERE

loc is not a join. It is a filter and a column list.

SELECT order_id, email
FROM Orders
WHERE total_amount > 100;

loc[:, "a":"f"] is a column range in the sheet. In SQL you name the columns.

Canonical translation

SELECT order_id, email
FROM Orders
WHERE total_amount > 100;