FINRA interview question

Can you draw out a SQL query for this problem?