GM Financial interview question

Code a SQL block based on a scenario