Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
15. Suspicious Bank Accounts
On this page

Problem

Table: Accounts

+----------------+------+
| Column Name    | Type |
+----------------+------+
| account_id     | int  |
| max_income     | int  |
+----------------+------+
account_id is the column with unique values for this table.
Each row contains information about the maximum monthly income for one bank account.

Table: Transactions

+----------------+----------+
| Column Name    | Type     |
+----------------+----------+
| transaction_id | int      |
| account_id     | int      |
| type           | ENUM     |
| amount         | int      |

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page