Fisher Investments interview question

Basic SQL questions. How would you go about visualization