Find Employees With Specific Job Titles and Seniority

Medium
where Google LinkedIn Apple

Find all employees whose job_title contains the word 'Engineer' and whose years_experience is at least 5. Return name, job_title, and years_experience, ordered by years_experience descending, then name.

Expected Output: Engineers with 5+ years experience.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...