Automate with Your Programming Language | Dataford Interview Questions

What is your preferred programming language, and how have you used it to automate a manual task in a Citi-style data workflow?

For this SQL exercise, use the workflow review data to identify repeated exception patterns. Write a query that returns only task types with more than one exception review.

Output

One row per task type with repeated exceptions
Columns: task_type, exception_count, last_exception_date
Ignore rows where task_type is NULL
Sort by exception_count descending, then task_type ascending

Schema

workflow_reviews

Column	Type	Description
review_idPK	INT	Unique review record identifier
task_type	VARCHAR(100)	Workflow task category
status	VARCHAR(20)	Review outcome, such as EXCEPTION or OK
review_date	DATE	Date the review was completed

Your question is Automate with Your Programming Language. 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