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

https://leetcode.com/problems/find-pivot-index/?envType=study-plan&id=level-1 Find Pivot Index - 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 pivotIndex(int[] nums) { int pivot = 0; int total_sum = Arrays.stream(nums).sum(); for(int i = 0; i < nums.le..

https://leetcode.com/problems/running-sum-of-1d-array/?envType=study-plan&id=level-1 Running Sum of 1d Array - 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[] runningSum(int[] nums) { Integer[] ans = new Integer[nums.length]; ans[0] = nums[0]; for (int..

https://leetcode.com/problems/customers-who-never-order/?envType=study-plan&id=sql-i Customers Who Never Order - 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 c.name as Customers from customers as c left join orders as o on c.Id = o.customerId where o.id is null;

https://leetcode.com/problems/find-customer-referee/?envType=study-plan&id=sql-i Find Customer Referee - 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 SQL에서는 비교 연산자에서는 NULL이 배제된다. (반면 논리 연산자에서는 NULL이 배제되지 않는다.) # Write your MySQL query statement below select name from customer wh..

https://leetcode.com/problems/recyclable-and-low-fat-products/ Recyclable and Low Fat Products - 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 from products where low_fats = 'Y' and recyclable = 'Y';

https://leetcode.com/problems/big-countries/?envType=study-plan&id=sql-i Big Countries - 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 name, population, area from World where area >= 3000000 or population >= 25000000;

백엔드 공부를 하다보면 아무리 JPA를 활용하더라도 Native Query에 익숙해야 원하는 데이터를 최대한 DB단에서 효율적으로 뽑아올 수 있음을 느꼈다. 10일 만에 SQL 문법을 뗄 수 있을지 모르겠다. 일단 화이팅!!

추천 대상 알고리즘 매우 오랜만에 하는 알린이, 새로운 언어로 알고리즘 도전하는 자들에게 문법 정리용