There's a "messages" table that has more than 1 million rows of information about the messages that were exchanged between users. The table includes the first three rows.Implement a SQL query to return the count of messages that include the phrase "Miss you". (Note: Take in to account the message may contain a capital "M" and lowercase "M". messagesmessage_idfrom_user_idto_user_iddate_sentdate_readmessage1343731721381022015-03-152015-03-15"Hi!!! Wanted to know how00:02:1700:03:05u were doing?! Miss you !! ."NULL"Don't forget to like andcomment on my new pic."2143844359374402015-03-1500:02:242015-03-1500:02:253233123412312322015-04-01"Let's hang out!"00:11:08Table Name: messagesmessage_id: Id of messagefrom_user_id: Id of user sending the messageto_user_id: Id of user receiving the messagedate_sent: date that the message was sentdate_read: date that the message was read. NULL if message has not been read.message: text of the message

Given Data : Table name : messages Table attributes : message_id from_user_id to_user_id…

Answered: There's a "messages" table that has…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

There's a "messages" table that has more than 1 million rows of information about the messages that were exchanged between users. The table includes the first three rows.

Implement a SQL query to return the count of messages that include the phrase "Miss you". (Note: Take in to account the message may contain a capital "M" and lowercase "M".

messages
message_id
from_user_id
to_user_id
date_sent
date_read
message
1
3437317
2138102
2015-03-15
2015-03-15
"Hi!!! Wanted to know how
00:02:17
00:03:05
u were doing?! Miss you !! ."
NULL
"Don't forget to like and
comment on my new pic."
2
1438443
5937440
2015-03-15
00:02:24
2015-03-15
00:02:25
3
2331234
1231232
2015-04-01
"Let's hang out!"
00:11:08
Table Name: messages
message_id: Id of message
from_user_id: Id of user sending the message
to_user_id: Id of user receiving the message
date_sent: date that the message was sent
date_read: date that the message was read. NULL if message has not been read.
message: text of the message

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions