A virtual data analyst job for students and freshers in India. Practise the work, not just the syntax.

Product

Scenario library
Pricing
How it works

For you

Students
Trainers & colleges
FAQ

Company

Contact
Institutions

© DataDesk. All companies, people and datasets are fictional.

Made for learners in India 🇮🇳

Conditional sum — practice · DataDesk

How it works
Scenarios
Practice
For trainers
Pricing

Log in Start free

CASE WHEN(9 / 20)

Intermediate

Conditional sum

For each account_id, return credits and debits (total amounts) in separate columns.

Tables

logins

user_idinteger
login_datedate

monthly_sales

monthdate
regionvarchar
revenueinteger

transactions

txn_idinteger
account_idinteger
txn_datedate
amountinteger
txn_typevarchar

Expected output

3 rows with columns account_id, credits, debits

Hints(0/2)

Solution

Unlocks after you solve it or after 3 submissions

SQL (DuckDB)

Ctrl + Enter to runLog in to save progress and earn XP

Run your code to see the output here.