SQL 문제 8 - Calculate Special Bonus LeetCode 1873 Calculate Special Bonus 풀이 -- ORACLE SELECT EMPLOYEE_ID , CASE WHEN MOD(EMPLOYEE_ID,2) = 0 OR SUBSTR(NAME,0,1) = 'M' THEN 0 ELSE SALARY END AS BONUS FROM EMPLOYEES; -- MYSQL SELECT EMPLOYEE_ID , CASE WHEN EMPLOYEE_ID % 2 = 0 OR LEFT(NAME,1) = 'M' THEN 0 ELSE SALARY END AS BONUS FROM EMPLOYEES; -- MSSQL SELECT EMPLOYEE_ID , CASE WHEN EMPLOYEE_ID % 2 = 0 OR LEFT(NAME,1) = 'M' THEN 0 ELSE SALARY END AS BONUS FROM EMPLOYEES; * 출처 Level up your coding ...
#
CalculateSpecialBonus_LeetCode1873
#
SQL
#
SQL_CalculateSpecialBonus
#
SQL_CalculateSpecialBonus_LeetCode1873
#
SQL_LeetCode1873
