#343 Finding Accounts Without Transactions Since a Given Date

Companies:

Russian Agricultural Bank

Themes:

SQLSubqueriesPractice

There are two tables: accounts and account transactions:

account(account_id, create_dt, client_id, status, balance);

transaction (transaction_id, create_dt, status, amount, account_id);

Find all accounts that have had no transactions since January 1, 2025.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.