Find accounts with zero transactions

Flag accounts as dormant if they have never appeared in the transactions table at all.

Return account_id and owner for every dormant account.

Schema

▸accounts

account_id	INT
owner	TEXT

▸transactions

id	INT
account_id	INT
amount	NUMERIC

Example input

▸accounts

▸transactions

↑ Read the question

Keep going

More subquery questions

mediumAccounts above their own branch's averageHSBC · subqueryBasic→mediumBranches beating the network's average growthStandard Chartered · subqueryBasic→mediumDrivers rated above averageGrab · subqueryBasic→mediumInactive subscribersCelcomDigi · subqueryBasic→

All subqueries and ctes questions →Learn subqueries and ctes first →

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.