MYSQL Query Recommendations for Trade Data [closed]

  Kiến thức lập trình

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


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.

New contributor

Ursula Battles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.