GM Financial Interview Question

Code a SQL block based on a scenario