Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
Bartleby Related Questions Icon

Related questions

Question

There's a "users" table and "messages" table included in the image. 

Implement a SQL query to return which users have more than 10 unread messages (NULL in the "date_read" column).

users
user_id
username
email
friend_count
3437315
janedoe2.0
janedoe2.0@email.com
5
3437316
princessluv8996
princessluv8996@email.com
600017
3437317
sk8ter4!f3
sk8ter4l!f3@email.com
583
Table Name: users
user_id: Id of user
username: name of user
email: email of user
friend_count: user's number of friends
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
expand button
Transcribed Image Text:users user_id username email friend_count 3437315 janedoe2.0 janedoe2.0@email.com 5 3437316 princessluv8996 princessluv8996@email.com 600017 3437317 sk8ter4!f3 sk8ter4l!f3@email.com 583 Table Name: users user_id: Id of user username: name of user email: email of user friend_count: user's number of friends 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
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
Text book image
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
Text book image
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
Text book image
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
Text book image
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
Text book image
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY