Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
26. Unused Accounts
On this page

Problem

Table: Accounts

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| account_id    | int     |
| account_name  | varchar |
+---------------+---------+
account_id is the primary key (column with unique values) for this table.
Each row of this table contains the ID and the name of an account in the bank.

Table: Transactions

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| transaction_id| int     |
| account_id    | int     |
| transaction_date | date |
+---------------+---------+

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page