SQL Experience in Analysis | Dataford Interview Questions

What is your experience with SQL, and how have you applied it in your analysis?

For this exercise, write a query that summarizes completed analysis records by analyst. Include only analysts with completed records and calculate their total reviewed records and identified issues.

Output

One row per analyst, with analyst_name, total_records_reviewed, and total_issues_found.
Sort by total_records_reviewed descending, then analyst_name ascending.

Schema

analysis_records

Column	Type	Description
analysis_idPK	INT	Unique identifier for an analysis record
analyst_name	VARCHAR(100)	Name of the analyst who performed the analysis
analysis_area	VARCHAR(100)	Area examined by the analyst
status	VARCHAR(20)	Current state of the analysis record
records_reviewed	INT	Number of records reviewed
issue_count	INT	Number of issues identified

Your question is SQL Experience in Analysis. 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