Fisher Investments Interview Question

Basic SQL questions. How would you go about visualization