https://leetcode.com/problems/rearrange-products-table/ Rearrange Products 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 product_id, 'store1' as store, store1 as price from Products where store1 is not null union select product_id, 'store2' as store, store2 as pric..
분류 전체보기
https://leetcode.com/problems/employees-with-missing-information/ 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 * from ( select a.employee_id from Employees as a left outer join Salaries as b on a.employee_id = b.employee_id where b.emp..
https://leetcode.com/problems/patients-with-a-condition/ 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 patient_id, patient_name, conditions 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, concat(upper(left(name, 1)), lower(substring(name, 2))) as name from Users order by user_id; Best SELECT USER_ID, (CONCAT(UPPER(SUBSTR(NAME, 1,..
https://leetcode.com/problems/delete-duplicate-emails/ 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 a from Person a, Person b where a.id > b.id and a.email = b.email; best DELETE FROM Person WHERE Id NOT IN (SELECT * FROM( SELECT MIN(Id) FROM Per..
https://leetcode.com/problems/swap-salary/ 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 = 'm', 'f', 'm'); best UPDATE Salary SET sex = (CASE WHEN sex = 'm' THEN 'f' ELSE 'm' END);
https://leetcode.com/problems/calculate-special-bonus/ 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 # Write your MySQL query statement below select employee_id, if (employee_id%2 = 1 and name not like 'M%', salary, 0) as bonus from Employees
