SQL Top N Query | Dataford Interview Questions

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

Your question is SQL Top N Query. Start with the requirements and the one table in the Question tab.

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

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

Your question is SQL Top N Query. Start with the requirements and the one table in the Question tab.

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