Charles Schwab Interview Question

A technical question was asked about the SQL needed to address a specific problem statement and was expected to give the exact syntax for the solution