728x90 SQL/LeetCode29 [LeetCode][SQL50] #24. User Activity for the Past 30 Days I 💻 문제 주소 : User Activity for the Past 30 Days I - LeetCode User Activity for the Past 30 Days I - LeetCode Can you solve this real interview question? User Activity for the Past 30 Days I - Table: Activity +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | session_id | int | | activity_date | date | | activity_typ leetcode.com 💻 문제 Write a solution .. 2024. 1. 4. [LeetCode][SQL50] #23. Number of Unique Subjects Taught by Each Teacher 💻 문제 주소 : Number of Unique Subjects Taught by Each Teacher - LeetCode Number of Unique Subjects Taught by Each Teacher - LeetCode Can you solve this real interview question? Number of Unique Subjects Taught by Each Teacher - Table: Teacher +-------------+------+ | Column Name | Type | +-------------+------+ | teacher_id | int | | subject_id | int | | dept_id | int | +-------------+-- leetcode.co.. 2024. 1. 3. [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. [LeetCode][SQL50] #20. Monthly Transactions I 💻 문제 주소 : Monthly Transactions I - LeetCode Monthly Transactions I - LeetCode Can you solve this real interview question? Monthly Transactions I - Table: Transactions +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | country | varchar | | state | enum | | amount | int | | trans_date | date leetcode.com 💻 문제 Write an SQL query to find for each month and.. 2023. 11. 16. 이전 1 2 3 4 5 6 다음 728x90 반응형
