FINRA interview question

Some sql, I don't remember it now..