I’m teaching myself SQL, and trying to answer real-life questions with some example scenarios and I need some recommendations for:

Scenario:

What will you see in your trade account or portfolio when a trade has already been made?

How to produce a result set that includes trade type, company name, and the trade date in an SQL query

My idea is to create two tables: Customer Account and Portfolio. Then, use a SELECT statement for columns “company name” FROM the Customer Account table and a SELECT statement for columns “trade type” and “trade date” FROM the Portfolio table, and maybe a join. I need some helpful tips on the best way to structure this query.
This may be overkill.