Your Fit for the Role | Dataford Interview Questions

What analytics software are you trained in and to what level?

Using the supplied PostgreSQL tables, write a query that returns the analytics software recorded for analyst 101 and the associated training level. Include only software with a matching training record.

Output

One row per trained software tool
Columns: software_name, proficiency_level, training_status
Order by proficiency from highest to lowest, then software name alphabetically

Schema

analytics_software

Column	Type	Description
software_idPK	INT	Unique identifier for an analytics software product
software_name	VARCHAR(100)	Name of the analytics software product
vendor	VARCHAR(100)	Software vendor

analyst_training

Column	Type	Description
training_idPK	INT	Unique training record identifier
analyst_id	INT	Identifier for the analyst
software_id	INT	Referenced analytics software identifier
proficiency_level	VARCHAR(30)	Recorded proficiency level
training_status	VARCHAR(30)	Source training status, if recorded

Your question is Your Fit for the Role. 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