Description
Find employees with highest salary.
Mission:Practice subquery patterns used in interviews.
Investigation:Find employees with highest salary.
Expected Outcome:Return the correct result set.
Concept tags:
#SUBQUERY
Estimated: 4 minDifficulty: Intermediate
Database Schema
Relationships
No relationships documented.
Tables
employees
idnamedepartmentsalarymanager_id
Monaco SQL EditorIntermediate4m
Loading...
SCAN
FILTER
GROUP
SORT
RESULT
Pipeline elapsed: 0ms
Shortcuts: Ctrl/Cmd+Enter run, Ctrl/Cmd+/ comment, Ctrl/Cmd+Shift+F format
#SUBQUERY
Result Summary
Expected: 1
Actual: 0
Needs update
Smart Hint: You returned fewer rows. Check JOIN/WHERE.
Progressive Hints
Hint 1: Start with the inner query.
Run a query to see results.
Tip: Explore table previews first to understand data relationships.