Skip to main content
All Questions

Employee Earnings.

Medium
Unlock detailed company stats for this questionUpgrade

You are given the employees table:

ColumnType
idinteger
first_namestring
last_namestring
ageinteger
sexstring
employee_titlestring
departmentstring
salaryinteger
targeinteger
bonusinteger
citystring
addressstring
manager_idinteger

Find employees who are earning more than their managers. Output the employee’s first name along with their corresponding salary. Your output should have the following columns: first_name (of the employee), manager_salary.

Related courses

Course

Data Analyst Interview Prep

Ace your data analyst interviews—whether you're targeting product, marketing, or business analyst roles. Tackle real take-home case studies, sharpen your technical and dashboarding skills, and get strategies from interviewers at top tech companies and startups.

Course

Data Science Interview Prep

Land your dream data science role at Google, Amazon, Microsoft, Meta, Apple, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.