SQL · Amazon · Medium
You are given two activity tables. The table mobile_logins records mobile activity with columns user_id (INT) and login_dt (DATE); the table desktop_logins records desktop activity with the same two columns. A single user may appear several times, sometimes more than once on the same calendar day, and the same user_id may be present in both tables. Restrict attention to logins whose date lies inside the fixed interval from 2025-08-29 through 2025-08-31, inclusive. Sort every…
Checking your access…