write the query 6 use the following relations

(Database question)

May use SQL if you what

6. The "most recent activity" of a user is his or her latest story or post. The "most recently active user is the user whose most recent activity occurred most recently Report the name of every user, and for the most recently active user they follow, report their name and email, and the date of their most-recent activity. If there is a tie for the most recently active user that a user follows, report a row for each of them