Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the below Queries: table [ [ Query # , Query Name,Query Fields,Table ( s ) , Other ] , [ Query 1 ,
Create the below Queries:
tableQuery #Query Name,Query Fields,TablesOtherQuery All Users,All fields,Users,naQuery All Chats,All fields,Chats,natableQueries tableQuery Names:Session Session etctableChatIdSessionfromUsertoUsermessageChats,tableList in sequence by ChatId.Enter criteria for Sessionfield for each sessionnumber in queries.Query Donna,tableChatIdSessionfromUsertoUserChats,tableList in alpha order by thetoUser and then by ChatIdQuery Peter,tablefromUsertoUsermessageTimemessageChats,tableInclude only messagesfrom Donna and JohnSort by message time fromlongest to shortest. Do notdisplay the message time.Query John,tableusernamemessagestoUsertableUsersChatstableList all messages sent by JohnSmith and sequenced bytoUser Should have join.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started