Jul 28, 2020 3:14 am
User
-------------
User_ID
Name
Phone_Number
User History
--------------
User_ID
Date
Action
Question: Write an SQL query that returns the name, phone number and most recent date for any user that has logged in over the last 30 days (you can tell a user has logged in if the action field in User History is set to "logged_on").
1 Reply
Jul 28, 2020 3:23 am
Select A. name, A. Phone_number, datediff(day, getdate(), date) as different
From User as A
Inner Join User History as B
ON A. User_id=B.User_id
Where different 1 between 30
Order by date desc;