DDSA Solutions

1873. Calculate Special Bonus

UnknownView on LeetCode
Database

Problem Overview

Calculate Special Bonus is a unknown-difficulty LeetCode problem. This is a common Database pattern in coding interviews. Study the solution below and note the time and space complexity before attempting variations on your own.

A full step-by-step explanation is being added. See the study guide for pattern-based practice.

Read the solution code below and trace through it on paper before submitting. For structured interview prep, follow our 30-day study guide.

1873.sql
MySQL
/* Write your T-SQL query statement below */
SELECT
  employee_id,
  CASE WHEN employee_id % 2 = 1 AND LEFT(name, 1) != 'M' THEN  salary ELSE  0 END AS bonus
FROM Employees
ORDER BY 1;
Was this solution helpful?

Related Problems