Welcome
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