SQL Query for Data Extraction | Dataford Interview Questions

Write a SQL query to extract specific data from a database for a Merck use case.

Use the supplied clinical_studies table to return records whose status is Active.

Output

One row per active study with study_id, study_name, therapeutic_area, status, and enrollment_count.
Sort by enrollment count from highest to lowest, placing NULL values last, then by study ID ascending.

clinical_studies

Column	Type	Description
study_idPK	INT	Unique identifier for the clinical study
study_name	VARCHAR(150)	Name of the clinical study
therapeutic_area	VARCHAR(80)	Therapeutic area associated with the study
status	VARCHAR(30)	Current study status
enrollment_count	INT	Number of enrolled participants

Your question is SQL Query for Data Extraction. 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.

Write a SQL query to extract specific data from a database for a Merck use case.

Use the supplied clinical_studies table to return records whose status is Active.

One row per active study with study_id, study_name, therapeutic_area, status, and enrollment_count.
Sort by enrollment count from highest to lowest, placing NULL values last, then by study ID ascending.

clinical_studies

Column	Type	Description
study_idPK	INT	Unique identifier for the clinical study
study_name	VARCHAR(150)	Name of the clinical study
therapeutic_area	VARCHAR(80)	Therapeutic area associated with the study
status	VARCHAR(30)	Current study status
enrollment_count	INT	Number of enrolled participants

Your question is SQL Query for Data Extraction. 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.