SQL Top N Query

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Top N Query. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Doximity wants to identify the most-viewed active physician profiles in California for a directory performance report. Write a PostgreSQL query that returns the top 10 qualifying records.

Requirements

Filter for profiles where profile_status is active and state is CA.
Return the physician ID, name, specialty, state, and monthly profile views, ordered from highest to lowest views. Return no more than 10 rows.

Schema

physician_profiles

Column	Type	Description
physician_idPK	INT	Unique physician profile identifier
physician_name	VARCHAR(100)	Physician display name
specialty	VARCHAR(100)	Primary medical specialty
state	VARCHAR(2)	U.S. state abbreviation
profile_status	VARCHAR(20)	Current profile status
monthly_profile_views	INT	Views during the most recent month

Tablesphysician_profiles

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results