루루의 우당탕탕 개발 스토리 루루의 우당탕탕 개발 스토리

https://leetcode.com/problems/find-total-time-spent-by-each-employee/?envType=study-plan&id=sql-i Find Total Time Spent by Each Employee - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select tb.event_day as day, tb.emp_id as emp_id, sum(diff_time) as total_time from (select even..

https://leetcode.com/problems/the-latest-login-in-2020/?envType=study-plan&id=sql-i The Latest Login in 2020 - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select user_id, max(time_stamp) as last_stamp from logins where date(time_stamp) between '2020-01-01' and '2020-12-31' grou..

https://leetcode.com/problems/game-play-analysis-i/ select player_id, min(event_date) as first_login from activity group by player_id;

https://leetcode.com/problems/customer-placing-the-largest-number-of-orders/?envType=study-plan&id=sql-i Customer Placing the Largest Number of Orders - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select customer_number from (select customer_number, count(order_number) as cnt f..

https://leetcode.com/problems/find-followers-count/ Find Followers Count - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select user_id, count(distinct follower_id) as followers_count from followers group by user_id order by user_id;

https://leetcode.com/problems/daily-leads-and-partners/?envType=study-plan&id=sql-i Daily Leads and Partners - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com SELECT date_id, make_name, COUNT(DISTINCT lead_id) AS unique_leads, COUNT(DISTINCT partner_id) AS unique_partners FROM Dail..

https://leetcode.com/problems/user-activity-for-the-past-30-days-i/?envType=study-plan&id=sql-i User Activity for the Past 30 Days I - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com select activity_date as day, count(distinct user_id) as active_users from activity where datediff('..

https://leetcode.com/problems/second-highest-salary/?envType=study-plan&id=sql-i Second Highest Salary - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com SELECT IFNULL( (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET 1), NULL) AS SecondHighestSalary; offset..