SQLTeam.com | Weblogs | Forums

Write the SQL code needed to answer the question: What are the brands purchased by the customers?


Is this some sort of homework or job interview?

What have you tried so far?

1 Like

You have a roadmap right in front of you. Find the table where the brands are stored and "follow the Yellow Brick Road" of FKs back to the table where the store the customers in. Then, just do the necessary joins to the aliased tables and you're done. This is obviously homework, course work, or an interview question. At least try.

1 Like