728x90 Database4 [SQL] Weather Observation Station 5 💻 문제 주소 : Weather Observation Station 5 | HackerRank Weather Observation Station 5 | HackerRankWrite a query to print the shortest and longest length city name along with the length of the city names.www.hackerrank.com 💻 문제Query the two cities in STATION with the shortest and lognest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there .. 2024. 4. 24. [SQL50] #27. Find Followers Count 💻 문제 주소 : https://leetcode.com/problems/find-followers-count/description/?envType=study-plan-v2&envId=top-sql-50 Find Followers Count - LeetCode Can you solve this real interview question? Find Followers Count - Table: Followers +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | follower_id | int | +-------------+------+ (user_id, follower_id) is the primary.. 2024. 1. 6. [LeetCode][SQL50] #22. Game Play Analysis IV 💻 문제 주소 : Game Play Analysis IV - LeetCode Game Play Analysis IV - LeetCode Can you solve this real interview question? Game Play Analysis IV - Table: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int | | event_date | date | | games_played | int | +--------- leetcode.com 💻 문제 Write a solution to report the fraction of play.. 2024. 1. 2. [LeetCode][SQL50] #21. Immediate Food Delivery II 💻 문제 주소 : https://leetcode.com/problems/immediate-food-delivery-ii/ Immediate Food Delivery II - LeetCode Can you solve this real interview question? Immediate Food Delivery II - Table: Delivery +-----------------------------+---------+ | Column Name | Type | +-----------------------------+---------+ | delivery_id | int | | customer_id | int | | order_date | d leetcode.com 💻 문제 If the customer's.. 2024. 1. 1. 이전 1 다음 728x90 반응형