DataDriven
LearnPracticeInterviewDiscussDailyJobs

The Upgrade Divide

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain
SQL
Difficulty
medium
Seniority
L4

Problem

Our growth team wants to know how far iOS 16, 17, and 18 have spread across our age groups. For each age group, show the number of users who ran a session on one of those iOS versions next to the total number of users with any session, largest groups first.

Summary

The install numbers don't match the hype.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons