問題 https://leetcode.com/problems/rank-scores/ 解いた SELECT score, DENSE_RANK() OVER (ORDER BY score DESC) 'rank' FROM Scores ORDER BY score DESC; 結果

問題 https://leetcode.com/problems/rising-temperature/ 解いた SELECT WWW.id FROM ( SELECT WW.id, W.temperature AS 'pre_temp', WW.temperature AS 'today_temp' FROM Weather AS W, Weather AS WW WHERE DATEDIFF(WW.recordDate, W.recordDate) = 1 O…

問題 https://leetcode.com/problems/median-of-two-sorted-arrays/ 解いた # @param {Integer[]} nums1 # @param {Integer[]} nums2 # @return {Float} def find_median_sorted_arrays(nums1, nums2) nums = (nums1 + nums2).sort result = 0 if nums.lengt…

問題 https://leetcode.com/problems/customers-who-never-order/ 解いた SELECT name AS 'Customers' FROM Customers LEFT JOIN Orders ON Customers.id = Orders.customerId WHERE customerId IS NULL; 結果

問題 https://leetcode.com/problems/duplicate-emails/ 解いた SELECT email FROM Person GROUP BY email HAVING COUNT(email) > 1; 結果

問題 https://leetcode.com/problems/employees-earning-more-than-their-managers/submissions/ 解いた サブクエリを使えば良い。 SELECT name AS Employee FROM Employee AS E WHERE salary > ( SELECT salary FROM Employee where id = E.managerId ) ; …

問題 https://leetcode.com/problems/valid-parentheses/ 解いた # @param {String} s # @return {Boolean} def valid_operators ["()", "{}", "[]"] end def is_valid?(char) valid_operators.include? char end def close_operators [")", "}", "]"] end d…

問題 https://leetcode.com/problems/longest-common-prefix/ 解いた # @param {String[]} strs # @return {String} def longest_common_prefix(strs) data = strs[0] result = "" data.chars.each_with_index do |char, index| if strs.all? { |str| str[in…