What are the customer id and name corresponding to accounts with a checking balance less than the largest checking balance?
CREATE TABLE checking (
    custid number,
    balance number
)

CREATE TABLE accounts (
    custid number,
    name text
)

CREATE TABLE savings (
    custid number,
    balance number
)
SELECT T1.custid, T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid WHERE T2.balance < (SELECT MAX(balance) FROM checking)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the customer id and name corresponding to accounts with a checking balance less than the largest checking balance? ### Input: CREATE TABLE checking (
    custid number,
    balance number
)

CREATE TABLE accounts (
    custid number,
    name text
)

CREATE TABLE savings (
    custid number,
    balance number
) ### Response: SELECT T1.custid, T1.name FROM accounts AS T1 JOIN checking AS T2 ON T1.custid = T2.custid WHERE T2.balance < (SELECT MAX(balance) FROM checking)