Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a query to list username of users who follow atleast 1 user but have never tweeted or retweeted any tweet. Sort the resulting list

Write a query to list username of users who follow atleast 1 user but have never tweeted or retweeted any tweet. Sort the resulting list by username, in ascending order.
Tables Schema as Below:
users
columnName dataType
id int
username varchar
email varchar
remember_token varchar
created_at datetime
updated_at datetime
password_digest varchar
tweets
columnName dataType
id int
content varchar
created_at datetime
updated_at datetime
UserTweetRelation
columnName dataType
id int
created_at datetime
retweet boolean
user_id varchar
tweet_id varchar
relationships
columnName dataType
id int
created_at datetime
updated_at datetime
follower_id int
followed_id int
Input
User Input is not applicable to this question.
Output
Run the code to print the output
Example
NA
Generated Expected Output
info icon
Insert Input

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 10g Insider Solutions

Authors: Arun R. Kumar, John Kanagaraj, Richard Stroupe

1st Edition

0672327910, 978-0672327919

Students also viewed these Databases questions