|
1
2
3
4
5
6
7
|
# Write your MySQL query statement below
select user_id, max(time_stamp) as last_stamp
from Logins
where 1=1
and time_stamp>='2020-01-01'
and time_stamp<'2021-01-01'
group by user_id
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1179. Reformat Department Table (0) | 2022.03.31 |
|---|---|
| leetcode 1407. Top Travellers (0) | 2022.03.31 |
| leetcode 1484. Group Sold Products By The Date (0) | 2022.03.30 |
| leetcode 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2022.03.30 |
| leetcode 1795. Rearrange Products Table (0) | 2022.03.30 |
댓글