Question: Please write a query to remove all the rows from the relationship table where either the follower _ id or the followed _ id values

Please write a query to remove all the rows from the "relationship" table where either the follower_id or the followed_id values are greater than 40, as we have only 40 users in our database.
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

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!