SourCaPlacement OS

Targeted Campus Assessment Prep

Setting up coding workspace...

Loading problem statement, test cases, and compiler sandbox

SourCaPlacement OS

Targeted Campus Assessment Prep

Loading SourCa...

Synchronizing placement benchmarks & campus recruitment roadmaps

SourCa/ Technical Preparation Platform

Companies Practice Progress College Insights Share Feedback Privacy

SourCa is an independent coding and assessment practice system designed from publicly available interview patterns. Not affiliated with or endorsed by any company.

INDEPENDENT PLATFORM

Practice Directory•

Monthly Active Users & Transaction Aggregationsql

Relational Database Schema

Monthly Active Users & Transaction Aggregation

Write an SQL query to find the total monthly transaction amount and count of unique transacting users for each month in 2024. ### Schema: `Transactions` | Column Name | Type | | :--- | :--- | | id | int | | userId | int | | amount | int | | transactionDate | varchar |

Tables & Sample Fixtures

Table: Transactions

id (int)	userId (int)	amount (int)	transactionDate (varchar)
1	10	500	2024-01-15
2	20	300	2024-01-20
3	10	200	2024-01-28
4	30	700	2024-02-05

query.sql

Execution Output Result

Click 'Run & Verify Query' to test your SQL against the sample test fixture.

SourCaPlacement OS

Targeted Campus Assessment Prep

Setting up coding workspace...

Loading problem statement, test cases, and compiler sandbox

Practice Directory•

Monthly Active Users & Transaction Aggregationsql

Relational Database Schema

Monthly Active Users & Transaction Aggregation

Tables & Sample Fixtures

Table: Transactions

id (int)	userId (int)	amount (int)	transactionDate (varchar)
1	10	500	2024-01-15
2	20	300	2024-01-20
3	10	200	2024-01-28
4	30	700	2024-02-05

query.sql

Execution Output Result

Click 'Run & Verify Query' to test your SQL against the sample test fixture.