First Impressions

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

We're studying the first impression our product makes, so for each visitor we look only at the earliest three pages they opened, in the order they viewed them. Across all visitors, surface the pages that appear most often in those opening views, keeping the three most common and any page tied at the third position.

Summary

The first three pages decide who stays.

Practice This Problem

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