Search ⌘K
Pinterest
Pinterest

Interview Core Track · Medium · 25 min

Final Account Balances

Use this Pinterest operations review to work on final account balances. Calculate the final balance per account_id. Credits add to the balance and debits sub...

Interview Core Track
Medium
25 min
query basics
joins
aggregation

Company labels are directional practice context, not official interview guidance.

Timer 00:00
Back to practice

Objective

Practice query basics through a Pinterest-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics
Prereq: filtering

Use this Pinterest operations review to work on final account balances. Calculate the final balance per account_id. Credits add to the balance and debits subtract from it. Return account_id and final_balance sorted by account_id.

Pro question
This is a Pro question

Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.

Upgrade to Pro — unlock all 254 problems
Editor
SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.