15. Suspicious Bank Accounts

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Vote For New Content

15. Suspicious Bank Accounts

Table of Contents

Contents are not accessible

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!

Table of Contents

Contents are not accessible