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

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 문법을 뗄 수 있을지 모르겠다. 일단 화이팅!!

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

https://leetcode.com/problems/range-sum-query-immutable/?envType=study-plan&id=programming-skills-i Range Sum Query - Immutable - 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 NumArray { int[] nums; public NumArray(int[] nums) { this.nums = nums; } public int sumRange(int l..

https://leetcode.com/problems/design-parking-system/?envType=study-plan&id=programming-skills-i Design Parking System - 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 ParkingSystem { int big_room, medium_room, small_room; public ParkingSystem(int big, int medium, int small) ..