Question: Consider the following schema for a simple social network. It maintains a collection of users, identified by unique handles (short names) User (handle.name, home city,

 Consider the following schema for a simple social network. It maintains

Consider the following schema for a simple social network. It maintains a collection of users, identified by unique "handles (short names) User (handle.name, home city, bio) Friend (handle, handle Message Candle text from city) For the following SQL query, Indicate which question it represents SELECT DISTINCT U handle FROM User Message M WHERE U handle - Message handie AND from_city home_city Select one: a Find the handles of users who wrote messages while in cities other than the one in which they live b. Find the handles of users who are friends with someone who is trends with them Find the names of users who either live in Kansas City or have written a message from Kansas City Od Find the names of users who both live in Kansas City and have written a message from Kansas City None of them

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!