SQL and Resume-Based Questions | Dataford Interview Questions

Tell me about the SQL work you have done that is most relevant to your resume, including any data manipulation you performed for risk analysis.

Write a SQL query that returns a concise risk-analysis work summary from the provided tables. Focus on the most relevant work items, their source systems, and the type of manipulation performed.

Output

One row per work item with a non-null status and a matching analyst assignment
Columns: work_item_id, analyst_name, source_system, manipulation_type, risk_focus, last_updated
Include only work items marked completed or in_progress
Sort by last_updated descending, then work_item_id ascending

Schema

analysts

Column	Type	Description
analyst_idPK	INT	Primary key for the analyst
analyst_name	VARCHAR(100)	Analyst name
team_name	VARCHAR(100)	Risk team name

risk_work_items

Column	Type	Description
work_item_idPK	INT	Primary key for the work item
analyst_id	INT	Analyst assigned to the work item
source_system	VARCHAR(100)	Source system used for the work item
manipulation_code	VARCHAR(20)	Internal code describing the type of data manipulation
risk_focus	VARCHAR(100)	Risk topic covered by the work item
status	VARCHAR(20)	Current status of the work item
last_updated	DATE	Date the work item was last updated

Your question is SQL and Resume-Based Questions. Start with the requirements and the two tables 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