Ford Motor Company Interview Question

SQL Join Table and find max count