자료구조 알고리즘

https://leetcode.com/problems/min-cost-climbing-stairs/ Min Cost Climbing Stairs - 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: int minCostClimbingStairs(vector& cost) { // 10, 15, 20, 0 // 0, 1, 2, 3 cost.push_back(0); for(int i = cost.size() - 3; i >= ..

https://leetcode.com/problems/climbing-stairs/ Climbing Stairs - 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: int climbStairs(int n) { int a = 1, b = 1, temp = 0; for(int i = 2; i

https://leetcode.com/problems/second-highest-salary/submissions/ Second Highest 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 select max(salary) as SecondHighestSalary from Employee where salary < (select max(salary) from Employee); /* select salary as SecondHighestSalar..

https://leetcode.com/problems/tree-node/ Tree Node - 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 id, case when p_id is null then 'Root' when id in (select distinct p_id from Tree) then 'Inner' else 'Leaf' end as type from Tree; best select id, IF(ISNULL(p_id), 'Root', IF..

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