SQL 문제 8 - Calculate Special Bonus LeetCode 1873

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 ...

원문링크 : SQL 문제 8 - Calculate Special Bonus LeetCode 1873