Question: This is what I have so far- select to_user_id, date_read from messages Inner join user_id on to_user_id.messages = user_id.users where date_read = NULL not sure

This is what I have so far- select to_user_id, date_read from

This is what I have so far-

select

to_user_id, date_read

from messages

Inner join user_id on to_user_id.messages = user_id.users

where date_read = NULL

not sure how to account for more than 10 messages

Consider the following users and messages tables to answer the question below. users user_id username email friend_count 3437315 janedoe2.0 janedoe2.0@email.com 5 3437316 600017 princessluv89 princessluv8996@email.co 96 m 3437317 sk8ter 41!f3 sk8ter41!f3@email.com 583 messages message_id rom_user_id to_user_ic date_sent read message 1 3437317 2138102 2015-03-15 00:02:17 2015-03-15 00:03:05 "Hi!!! Wanted know how were doing?! Miss you !!.." 2 1438443 5937440 NULL 2015-03-15 00:02:24 "Don't forget to like and comment on my new pic... 3 2331234 1231232 2015-03-15 00:02:25 2015-04-01 00:11:08 "Let's hang out!" Question 5: Write a SQL query to determine which users have more than 10 unread messages

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!

Accounting Services Corporation entered into the following transactions during 2010: a. The company started as a corporation with a $14,700 cash contribution from the owners in exchange for common...

18.1 Identify and describe each of the following dates that are associated with a dividend payment on common stock: February 16 February 24 February 26 March 14

2. Did you find that as relationships become closer and more interdependent, there are more opportunities for conflict, the more trivial complaints become significant ones, and feelings become more...

This is a partial adjusted trial balance of Fenske Company. InstructionsAnswer these questions, assuming the year begins January 1.(a) If the amount in Supplies Expense is the January 31 adjusting...

This is what I have so far- select to_user_id, date_read from messages Inner join user_id on to_user_id.messages = user_id.users where date_read = NULL not sure how to account for more than 10...

What are some of the management problems associated with allowing service employees to exercise judgment in meeting customer needs?

In a gambling game, Player A and Player B both have a $1 and a $5 bill. Each player selects one of the bills without the other player knowing the bill selected. Simultaneously they both reveal the...

Explain the relationship between the degree of operating leverage and the sensitivity of a project s potential returns to market risk

Question 16: Is an increase in the volatility of a stock's price good for the owner of a call option? Is it good for the owner of a put option? It is bad for both. It is bad for the call owner but...

What is the basis for Security Concerns in Cloud Computing?

Should Needs and GAP Analyses be equally applied in terms of effort when off-theshelf System Solutions being acquired versus building a custom system using Vendors or internal Programming Staff?

Describe the three main Cloud Computing Environments.