CarGurus Interview Question

SQL problems with two tables. Need inner join and group by. Then some follow up questions