CRM and EPM Tool Experience | Dataford Interview Questions

What is your experience with Salesforce administration, configuration, or financial planning suites like Oracle Cloud EPM?

For this SQL exercise, identify candidates with positive experience in Salesforce or Oracle Cloud EPM and summarize their strongest relevant experience record.

Output

One row per candidate and relevant platform.
Return candidate_id, candidate_name, relevant_platform, max_years_experience, and most_recent_use.
Exclude other platforms and zero-year records. Sort by maximum experience descending, then candidate ID ascending.

Schema

candidates

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(100)	Candidate name

platform_experience

Column	Type	Description
experience_idPK	INT	Unique experience record identifier
candidate_id	INT	Candidate associated with the experience record
platform_name	VARCHAR(100)	Platform or suite name
years_experience	DECIMAL(4,1)	Years of reported experience
last_used_date	DATE	Date the platform was most recently used

Your question is CRM and EPM Tool Experience. 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