Excel Expertise for Analysis | Dataford Interview Questions

What is your Excel expertise?

Use the provided employee skill data to classify each employee into an expertise level based on completed Excel tasks and training hours. Return only employees with a recorded expertise level.

Output

One row per employee with a non-NULL expertise level
Columns: employee_name, expertise_level, completed_tasks, training_hours
Sort by expertise_level alphabetically, then employee_name alphabetically
Rows with a NULL in expertise_level are ignored

Output details

Classify as Advanced for at least 20 completed tasks and 40 training hours, Intermediate for at least 10 and 20, and Beginner otherwise.

Schema

employee_excel_skills

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
completed_tasks	INT	Number of completed Excel tasks
training_hours	INT	Hours of Excel training completed
expertise_level	VARCHAR(20)	Recorded expertise label, may be NULL

Your question is Excel Expertise for 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