![]()
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..
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,..
