Question: Create the below Queries: table [ [ Query # , Query Name,Query Fields,Table ( s ) , Other ] , [ Query 1 ,

Create the below Queries:
\table[[Query #,Query Name,Query Fields,Table(s),Other],[Query 1,All Users,All fields,Users,n/a],[Query 2,All Chats,All fields,Chats,n/a],[\table[[Queries 3-],[8]],\table[[Query Names:],[Session 0],[Session 1],[etc]],\table[[ChatId],[Session],[fromUser],[toUser],[message]],Chats,\table[[List in sequence by ChatId.],[Enter criteria for Session],[field for each session],[number in queries.]]],[Query 9,Donna,\table[[ChatId],[Session],[fromUser],[toUser]],Chats,\table[[List in alpha order by the],[toUser and then by ChatId]]],[Query 10,Peter,\table[[fromUser],[toUser],[messageTime],[message]],Chats,\table[[Include only messages],[from Donna1 and John1.],[Sort by message time from],[longest to shortest. Do not],[display the message time.]]],[Query 11,John,\table[[username],[messages],[toUser]],\table[[Users],[Chats]],\table[[List all messages sent by John],[Smith and sequenced by],[toUser. Should have 1 join.]]]]
 Create the below Queries: \table[[Query #,Query Name,Query Fields,Table(s),Other],[Query 1,All Users,All fields,Users,n/a],[Query

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!