Data Interview Qs - Maximum total compensation

InterviewQs

Maximum total compensation

SQL Database Querying Window Function Subquery Self-Join

Forward this email to a friend or colleague and challenge them to solve it.

Hi, 

You're given the following table showing information about employees at a company:

Table: emp_info

department emp_id salary_annual bonus
eng 1234 150000 20000
eng 1235 125000 15000
eng 1236 110000 17000
sales 4454 110000 25000
sales 4432 145000 7000
marketing 4430 130000 12000
marketing 1299 135000 18000

Using the table above, write a SQL query to return the emp_id of the employee with the highest total compensation. Make sure your query is able to handle potential ties (e.g. if there is a tie, should return all emp_ids that tie for the highest total compensation).

You can view/query the data in an interactive SQL fiddle here.


 

You’ve accumulated 345 questions since joining our email list. Create a premium account to access detailed solutions to each problem (including this one) + our new Case studies.


Was this email forwarded to you? You can join our list here to receive questions

How did you like today's question?

15411 Boischatel, Montreal, QC, H9H1Y7, Canada
Don't want to get these emails anymore? We'll forgive you if you unsubscribe

Older messages

5-year changes in candy production

Monday, September 12, 2022

Data Analysis, Python, Pandas, Statistics, T-test, External Dataset, InterviewQs 5-year changes in candy production Data Analysis Python Pandas Statistics T-test External Dataset Forward this email to

Programming the Tower of Hanoi

Friday, September 9, 2022

Python, Algorithms, Loops, Recursion, InterviewQs Programming the Tower of Hanoi Python Algorithms Loops Recursion Forward this email to a friend or colleague and challenge them to solve it. Hi, The

Probability of a robbery

Wednesday, September 7, 2022

Probability Theory, Probability Reasoning, Complement Rule, InterviewQs Probability of a robbery Probability Theory Probability Reasoning Complement Rule Forward this email to a friend or colleague and

Checking user retention and churn in SQL

Monday, September 5, 2022

SQL, Database Querying, Window Function, Subquery, Self-Join, InterviewQs Checking user retention and churn in SQL SQL Database Querying Window Function Subquery Self-Join Forward this email to a

Price per calorie of various snack foods

Friday, September 2, 2022

Data Analysis, Python, Pandas, Data Manipulation, InterviewQs Price per calorie of various snack foods Data Analysis Python Pandas Data Manipulation Forward this email to a friend or colleague and

You Might Also Like

Stripe changes its … stripes

Wednesday, April 24, 2024

TikTok on the president's docket and Nvidia acquires Run:ai View this email online in your browser By Christine Hall Wednesday, April 24, 2024 Good afternoon, and welcome to TechCrunch PM! Today

💪 You Can Use Copilot AI as a Personal Trainer — Why Your Laptop Needs a Docking Station

Wednesday, April 24, 2024

Also: Here's How to Make Your Apple ID Recoverable, and More! How-To Geek Logo April 24, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to

JSK Daily for Apr 24, 2024

Wednesday, April 24, 2024

JSK Daily for Apr 24, 2024 View this email in your browser A community curated daily e-mail of JavaScript news JSK Weekly - 24th April, 2024 React 19 has introduced many great functionalities and

Daily Coding Problem: Problem #1422 [Hard]

Wednesday, April 24, 2024

Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Airbnb. Given a list of integers, write a function that returns the largest sum of non-

Charted | Artificial Intelligence Patents, by Country 🤖

Wednesday, April 24, 2024

This visualization shows which countries have been granted the most AI patents each year, from 2012 to 2022. View Online | Subscribe Presented by: New on VC+: Our Visual Briefing on the IMF's World

Save your seat: 1Password’s 2024 Security report insights webinar

Wednesday, April 24, 2024

Join us April 25th. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏

Top Tech Deals 📱 LG Flex TV, Google Pixel 7, DJI Mini 3, and More

Wednesday, April 24, 2024

Get yourself a discounted DJI drone, save on the Pixel 7, or score some PC and phone accessories. How-To Geek Logo April 24, 2024 Top Tech Deals: LG Flex TV, Google Pixel 7, DJI Mini 3, and More Find

The Protest Song Wakes Up 🎙️

Wednesday, April 24, 2024

Is this song the future of musical protest? Here's a version for your browser. Hunting for the end of the long tail • April 24, 2024 The Protest Song Wakes Up A buzzy protest song about the

JSK Weekly - 24th April, 2024

Wednesday, April 24, 2024

React 19 has introduced many great functionalities and features, among which the useOptimistic hook stands out. The useOptimistic hook offers a seamless way to manage UI states during asynchronous

The clock’s ticking for TikTok

Wednesday, April 24, 2024

The US Senate has passed a bill that would ban TikTok if its US business is not divested by Bytedance View this email online in your browser By Alex Wilhelm Wednesday, April 24, 2024 Good morning, and