Question: Task 12: Insert Records to Message-Image Table Construct the SQL statement to insert 5 new records in the message_image intersection table. Note: You are required


Task 12: Insert Records to Message-Image Table Construct the SQL statement to insert 5 new records in the "message_image" intersection table. Note: You are required to add at least one record where at least one of Michael Phelp's messages includes at least one image. Also, you are required to add at least one message that has multiple images. Task 13: Find All of the Messages that Michael Phelps Sent Construct the SQL statement to find all of the messages that Michael Phelps sent. Note: You must use the WHERE clause to set the conditions for this query. Display the following columns - Sender's first name - Sender's last name - Receiver's first name - Receiver's last name Message ID - Message - Message Timestamp
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
