5. Number of Transactions per Visit

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Table of Contents

Contents are not accessible

Problem

Table: Visits

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| user_id       | int     |
| visit_date    | date    |
+---------------+---------+
(user_id, visit_date) is the primary key (combination of columns with unique values) for this table.
Each row of this table indicates that user_id has visited the bank in visit_date.

Table: Transactions

+------------------+---------+
| Column Name      | Type    |
+------------------+---------+
| user_id          | int     |
| transaction_date | date    |

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible