CREATE TABLE checking (custid NUMBER, balance NUMBER)
CREATE TABLE savings (custid NUMBER, balance NUMBER)
CREATE TABLE accounts (custid NUMBER, name CLOB)

What are the names of customers with a higher checking balance than savings balance?
SELECT T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid JOIN savings AS T3 ON T1.custid = T3.custid WHERE T2.balance > T3.balance
SELECT "T1"."name" FROM "accounts" "T1" JOIN "checking" "T2" ON "T1"."custid" = "T2"."custid" JOIN "savings" "T3" ON "T1"."custid" = "T3"."custid" AND "T2"."balance" > "T3"."balance"