Question

user_follow? id INT ?following_user_id INT ?followed_user_id INT weight INT user +id INT first_name VARCHAR(128) last_name VARCHAR(128) user_interest ? user_id INT interest_id INT interest id INT name VARCHAR(100) DOB DATE step_taken id INT ?user_id INT step_id INT when_started TIMESTAMP when_finished TIMESTAMP rating TINYINT step id INT title VARCHAR(50) theme id INT name VARCHAR(100) step_theme ? theme_id INT step_id INT

          user_follow?
id INT
?following_user_id INT
?followed_user_id INT
weight INT
user
+id INT
first_name VARCHAR(128)
last_name VARCHAR(128)
user_interest ?
user_id INT
interest_id INT
interest
id INT
name VARCHAR(100)
DOB DATE
step_taken
id INT
?user_id INT
step_id INT
when_started TIMESTAMP
when_finished TIMESTAMP
rating TINYINT
step
id INT
title VARCHAR(50)
theme
id INT
name VARCHAR(100)
step_theme ?
theme_id INT
step_id INT

userfollow?
id INT
?followinguserid INT
?followeduserid INT
weight INT
user
+id INT
firstname VARCHAR(128)
lastname VARCHAR(128)
userinterest ?
userid INT
interestid INT
interest
id INT
name VARCHAR(100)
DOB DATE
steptaken
id INT
?userid INT
stepid INT
whenstarted TIMESTAMP
whenfinished TIMESTAMP
rating TINYINT
step
id INT
title VARCHAR(50)
theme
id INT
name VARCHAR(100)
steptheme ?
themeid INT
stepid INT

Added by Marcus W.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Nick Johnson

Step 1

We can do this by joining the user_follow table with the Wstep_taken table, filtering for Alice and Bob's user IDs. SELECT wt.step_id, s.title FROM user_follow uf JOIN Wstep_taken wt ON uf.followed_user_id = wt.following_user_id JOIN step s ON wt.step_id = Show more…

Show all steps

Thanks for your feedback!

Write one SQL statement to answer each question. Do not use views or temporary tables to answer the questions. SQL Script address: [link] Provide a list of the titles of all Steps that have been taken by both Alice (id = 1) and Bob (id = 2), along with the combined number of times they have taken the Step. user_follow: - id INT Wstep_taken: - following_user_id INT - followed_user_id INT - id INT - user_id INT - step_id INT - when_started TIMESTAMP user: - weight INT - id INT - theme_id INT - first_name VARCHAR(128) - last_name VARCHAR(128) - DOB DATE - when_finished TIMESTAMP - name VARCHAR(100) - rating TINYINT user_interest: - user_id INT - interest_id INT step_theme: - step_id INT - theme_id INT step: - id INT - theme_id INT - interest_id INT - step_id INT - title VARCHAR(50) - name VARCHAR(100)