CREATE TABLE checking (custid DECIMAL, balance DECIMAL)
CREATE TABLE savings (custid DECIMAL, balance DECIMAL)
CREATE TABLE accounts (custid DECIMAL, name TEXT)

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" AS "T1" JOIN "checking" AS "T2" ON "T1"."custid" = "T2"."custid" JOIN "savings" AS "T3" ON "T1"."custid" = "T3"."custid" AND "T2"."balance" > "T3"."balance"