MarketAxess interview question

Basic questions on SQL queries