SQL (152) 썸네일형 리스트형 [SQL] Top Travellers(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Top Travellers 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/top-travellers/description/ 2. 문제 Column name Type id int name varchar Column name Type id int user_id int distance int [문제] Write a solution to report the distance traveled by each user. Return the result table ordered by travelled_distance in descending order, .. [SQL] Capital Gain/Loss(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Capital Gain/Loss 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/capital-gainloss/description/ 2. 문제 Column name Type stock_name varchar operation enum operation_day int price int [문제] Write a solution to report the Capital gain/loss for each stock. The Capital gain/loss of a stock is the total gain or loss after buying and.. [SQL] Movie Rating(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Movie Rating 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/movie-rating/description/ 2. 문제 Column name Type movie_id int title varchar Column name Type user_id int name varchar Column name Type movie_id int user_id int rating int created_at date [문제] Write a solution to: Find the name of the user who has rated the greatest.. [SQL] List the Products Ordered in a Period(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 List the Products Ordered in a Period 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/list-the-products-ordered-in-a-period/description/ 2. 문제 Column name Type product_id int product_name varchar product_category varchar Column name Type product_id int order_date date unit int [문제] Write a solution to get the names of produc.. [SQL] Restaurant Growth(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Restaurant Growth 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/restaurant-growth/description/ 2. 문제 Column name Type customer_id int name varchar visited_on date amount int [문제] You are the restaurant owner and you want to analyze a possible expansion (there will be at least one customer every day). Compute the moving ave.. [SQL] Students and Examinations(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Students and Examinations 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/students-and-examinations/description/ 2. 문제 Column name Type student_id int student_name varchar Column name Type subject_name varchar Column name Type student_id int subject_name varchar [문제] Write a solution to find the number of times each student .. [SQL] Average Selling Price(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Average Selling Price 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/average-selling-price/description/ 2. 문제 Column name Type product_id int start_date date end_date date price int Column name Type product_id int purchase_date date units int [문제] Write a solution to find the average selling price for each product. average_.. [SQL] Queries Quality and Percentage(LeetCode/Oracle) 안녕하세요! 이번 포스팅은 LeetCode에 있는 Queries Quality and Percentage 문제를 OracleDB로 풀어보려고 합니다! (모든 문제는 Oracle로 풀이하겠습니다.) 1. 문제 링크 : https://leetcode.com/problems/queries-quality-and-percentage/description/ 2. 문제 Column name Type query_name varchar result varchar position int rating int [문제] We define query quality as: The average of the ratio between query rating and its position. We also define poor query.. 이전 1 2 3 4 5 6 ··· 19 다음