Practice Interview Questions
| Question | Status |
|---|---|
A conversion at Chime is someone who sets up payroll direct deposit of at least $200 per month with their employer. To identify a payroll direct deposit transaction, we look for members who are getting paid a similar amount by the same company on a recurring basis.
The majority of our members get paid on a set recurring basis. We also know their paychecks will be for similar amounts. We therefore look for the following:
Write a query that identifies the members converting to direct deposit and the date of conversion.
transactions table:
| Column Name | Description |
|---|---|
| id | Unique transaction identifier |
| transaction_date | Date when the transaction occurred |
| transaction_amount | Amount of money in the transaction |
| employer | Employer who issued the payroll deposit |
| user_id | Unique member identifier receiving the deposit |
| user_id | conversion_date |
|---|---|
| 2 | 2022-01-03 |
| 3 | 2023-01-01 |
| 4 | 2023-04-12 |
A conversion at Chime is someone who sets up payroll direct deposit of at least $200 per month with their employer. To identify a payroll direct deposit transaction, we look for members who are getting paid a similar amount by the same company on a recurring basis.
The majority of our members get paid on a set recurring basis. We also know their paychecks will be for similar amounts. We therefore look for the following:
Write a query that identifies the members converting to direct deposit and the date of conversion.
transactions table:
| Column Name | Description |
|---|---|
| id | Unique transaction identifier |
| transaction_date | Date when the transaction occurred |
| transaction_amount | Amount of money in the transaction |
| employer | Employer who issued the payroll deposit |
| user_id | Unique member identifier receiving the deposit |
| user_id | conversion_date |
|---|---|
| 2 | 2022-01-03 |
| 3 | 2023-01-01 |
| 4 | 2023-04-12 |