본문 바로가기
728x90

ROUND5

[SQL] Weather Observation Station 18 💻 문제 주소 :  Weather Observation Station 18 | HackerRank  The PADS | HackerRankQuery the name and abbreviated occupation for each person in OCCUPATIONS.www.hackerrank.com 💻 문제Consider P1(a, b) and P2(c, d) to be two points on a 2D plane.-. a happens to equal the minimum value in Northern Latitude (LAT_N in STATION).-. b happens to equal the minimum value in Western Longitude (LONG_W in STATION)... 2024. 5. 3.
[LeetCode][SQL50] #19. Queries Quality and Percentage 💻 문제 주소 : Percentage of Users Attended a Contest - LeetCode Percentage of Users Attended a Contest - LeetCode Can you solve this real interview question? Percentage of Users Attended a Contest - Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar | +-------------+---------+ user_id is the leetcode.com 💻 문제 Write a soluti.. 2023. 11. 15.
[LeetCode][SQL50] #18. Percentage of Users Attended a Contest 💻 문제 주소 : Percentage of Users Attended a Contest - LeetCode Percentage of Users Attended a Contest - LeetCode Can you solve this real interview question? Percentage of Users Attended a Contest - Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar | +-------------+---------+ user_id is the leetcode.com 💻 문제 Write a soluti.. 2023. 11. 15.
[LeetCode][SQL50] #17. Project Employees I 💻 문제 주소 : Project Employees I - LeetCode Project Employees I - LeetCode Can you solve this real interview question? Project Employees I - Table: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +-------------+---------+ (project_id, employee_id) is th leetcode.com 💻 문제 Write an SQL query that reports the average experie.. 2023. 11. 15.
[LeetCode][SQL50] #14. Confirmation Rate 💻 문제 주소 : Confirmation Rate - LeetCode Confirmation Rate - LeetCode Can you solve this real interview question? Confirmation Rate - Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +----------------+----------+ user_id is the colum leetcode.com 💻 문제 Write a solution to find the confirmation rate of each .. 2023. 11. 13.
728x90
반응형