CarGurus interview question

Basic SQL statements, table joins etc