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 🇮🇳

NULLs and aggregates — practice · DataDesk

How it works
Scenarios
Practice
For trainers
Pricing

Log in Start free

NULL handling(7 / 20)

Intermediate

NULLs and aggregates

For student 15's final exam, return papers (rows), scored (non-missing scores) and avg_score (2 decimals).

Tables

fees

student_idinteger
amountinteger
due_datedate
paid_datedate

marks

student_idinteger
subject_idinteger
examvarchar
scoreinteger

students

student_idinteger
namevarchar
classvarchar
gendervarchar
dobdate
cityvarchar

subjects

subject_idinteger
subject_namevarchar

Expected output

1 row with columns papers, scored, avg_score

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.