TradingHub interview question

How to write a SQL select statement