본문 바로가기
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.
728x90
반응형