IT/코딩테스트 (111) 썸네일형 리스트형 [Leetcode] 620. Not Boring Movies https://leetcode.com/problems/not-boring-movies/ SELECT * FROM Cinema WHERE (MOD(id, 2) = 1) AND (description != "boring") ORDER BY rating desc; [Leetcode] 26. Remove Duplicates from Sorted Array https://leetcode.com/problems/remove-duplicates-from-sorted-array/ class Solution: def removeDuplicates(self, nums: List[int]) -> int: count = len(nums) before = nums[0] for i in range(1, len(nums)): if before == nums[i]: nums[i] = 101 count -= 1 else: before = nums[i] nums.sort() return count [Leetcode] 1068. Product Sales Analysis I https://leetcode.com/problems/product-sales-analysis-i/ SELECT p.product_name, s.year, s.price FROM Sales as s INNER JOIN Product as p ON s.product_id = p.product_id; [Leetcode] 283. Move Zeroes https://leetcode.com/problems/move-zeroes/ class Solution: def moveZeroes(self, nums: List[int]) -> None: count = nums.count(0) if count == len(nums): return for i in range(count): nums.remove(0) nums.append(0) [Leetcode] 1378. Replace Employee ID With The Unique Identifier https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/ SELECT u.unique_id, e.name FROM Employees AS e LEFT JOIN EmployeeUNI AS u ON e.id = u.id; [Leetcode] 595. Big Countries https://leetcode.com/problems/big-countries/ SELECT name, population, area FROM world WHERE area >= 3000000 OR population >= 25000000; [Leetcode] 584. Find Customer Referee https://leetcode.com/problems/find-customer-referee/ SELECT name FROM Customer WHERE referee_id IS NULL OR referee_id != 2; [Leetcode] 1757. Recyclable and Low Fat Products https://leetcode.com/problems/recyclable-and-low-fat-products/ SELECT product_id FROM Products WHERE low_fats = "Y" AND recyclable = "Y"; 이전 1 ··· 9 10 11 12 13 14 다음