Java and SQL Basics | Dataford Interview Questions

Explain your background with Java and SQL.

Demonstrate the SQL portion by returning active engineers who have recorded experience with both Java and SQL. Include engineers even when one experience value is unknown.

Output

One row per qualifying engineer with employee_id, employee_name, java_years, and sql_years.
Exclude inactive engineers and engineers missing either skill record.
Order by employee_name, then employee_id.

Schema

engineers

Column	Type	Description
employee_idPK	INT	Unique engineer identifier
employee_name	VARCHAR(100)	Engineer name
employment_status	VARCHAR(20)	Current employment status

engineer_skills

Column	Type	Description
skill_idPK	INT	Unique skill record identifier
employee_id	INT	Engineer associated with the skill
skill_name	VARCHAR(50)	Recorded technical skill
years_experience	INT	Years of experience, when known

Your question is Java and SQL Basics. 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