select user_id

from emailsas e

join textsas tone.email_id=t.email_id

where date_add(date(e.signup_date), Interval1 Day)=date (t.action_date)and signup_action='Verified'

order by user_id

| # | Title | Solutions | Video | Difficulty | Tag

|------|----------------|-----------------------------------------------------------------------------------------------------------------------|---------------|---------------|-------------

| 3172|[Second Day Verification](https://leetcode.com/problems/second-day-verification/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_3172.sql)|| Easy|

| 1757|[Recyclable and Low Fat Products](https://leetcode.com/problems/recyclable-and-low-fat-products/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1757.sql)|| Easy|

| 1741|[Find Total Time Spent by Each Employee](https://leetcode.com/problems/find-total-time-spent-by-each-employee/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1741.sql)|| Easy|

| 1729|[Find Followers Count](https://leetcode.com/problems/find-followers-count/)|[Solution](https://github.com/fishercoder1534/Leetcode/blob/master/database/_1729.sql)|| Easy|