[leetcode][Database][Hard] 1369. Get the Second Most Recent Activity

1 · ZhengWei, Liu · Dec. 13, 2022, 12:10 a.m.
Description Table: UserActivity +---------------+---------+ | Column Name | Type | +---------------+---------+ | username | varchar | | activity | varchar | | startDate | Date | | endDate | Date | +---------------+---------+ There is no primary key for this table. It may contain duplicates. This table contains information about the activity performed by each user in a period of time. A person with username performed an activity from startDate to endDate....