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

What is the checking balance of the account whose owner s name contains the substring ee ?
SELECT T2.balance FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid WHERE T1.name LIKE '%ee%'
SELECT "T2"."balance" FROM "accounts" "T1" JOIN "checking" "T2" ON "T1"."custid" = "T2"."custid" WHERE "T1"."name" LIKE '%ee%'