Ford Motor Company interview question

SQL Join Table and find max count