ORACLE SQL Hello I need help with the following questions: Write a query on the

Question

ORACLE SQL

Hello I need help with the following questions:

Write a query on the following scenario schema that involves table joins and a WHERE clause.

Figure 1 Four Tables of the Club Blog Schema club member tag_member_w_interest (PK member_username username password interest id proifleinfo interest 1PK member username first name last_name interest id interest tag mi street city state zipcode dob Figure 2 Three More Tables of the Club Blog Schema blog post PK post id post title post_content create _datetime status member_username post comment post prop 1PK comment id comment content create_datetime member username post id prop id prop type create_ datetime member username postid

Explanation / Answer

Let me know if you have any doubt.

Answer)

Select first, last name and interest id for a member who is from 'NewYork' city.

Select P.first_name, P.last_name , T.interest_id
from profile_info as P join tag_member_w_interest as T
on P.member_username=T.member_username
where P.city='NewYork';

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.