728x90
https://leetcode.com/problems/game-play-analysis-i/
[problem]
[analysis]
1. eventdate가 여러 데이터가 있으므로 min을 이용
2. id group by
[solution]
728x90
'MS SQL > MS SQL : Leetcode' 카테고리의 다른 글
| SQL - 627. Swap Salary (update, case when) (0) | 2022.04.27 |
|---|---|
| SQL - 586. Customer Placing the Largest Number of Orders (select, count) (0) | 2022.04.26 |
| SQL - 183. Customers Who Never Order (left join, where) (0) | 2022.04.26 |
| SQL - Leetcode 620. Not Boring Movies (where, order by) (0) | 2022.04.25 |
| SQL - Leetcode 175. Combine Two Tables (left join) (0) | 2022.04.25 |