루루의 우당탕탕 개발 스토리 루루의 우당탕탕 개발 스토리

https://leetcode.com/problems/employees-with-missing-information/?envType=study-plan&id=sql-i Employees With Missing Information - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com SELECT employee_id FROM Employees WHERE employee_id NOT IN (SELECT employee_id FROM Salaries) UNION SEL..

https://leetcode.com/problems/patients-with-a-condition/?envType=study-plan&id=sql-i Patients With a Condition - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select * from Patients where conditions like 'DIAB1%' or conditions like '% DIAB1%';

https://leetcode.com/problems/group-sold-products-by-the-date/ Group Sold Products By The Date - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select sell_date, count(distinct product) as num_sold, group_concat(distinct product) as products from Activities group by sell_date orde..

https://leetcode.com/problems/fix-names-in-a-table/ Fix Names in a Table - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select user_id, initcap(name) as name from users order by user_id; SQL 문법 참고 : https://1day1code.tistory.com/entry/SQL-%EB%AC%B8%EC%9E%90-%ED%95%A8%EC%88%98-LO..

https://leetcode.com/problems/isomorphic-strings/?envType=study-plan&id=level-1 Isomorphic Strings - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com class Solution { public boolean isIsomorphic(String s, String t) { HashMap map = new HashMap(); int i = 0; while (i < s.length()){ if..

https://leetcode.com/problems/delete-duplicate-emails/?envType=study-plan&id=sql-i Delete Duplicate Emails - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com delete from person where id not in ( select sub.min_id from ( select min(id) as min_id, email from person group by email) as ..

https://leetcode.com/problems/swap-salary/?envType=study-plan&id=sql-i Swap Salary - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com UPDATE Salary SET sex = IF (sex = 'f','m','f') SQL의 if는 DDL에서도 사용 가능

https://leetcode.com/problems/calculate-special-bonus/?envType=study-plan&id=sql-i Calculate Special Bonus - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select employee_id, if (employee_id % 2 = 1 AND name NOT LIKE 'M%', salary, 0) as bonus from Employees order by employee_id;