Error when trying to create view: 'car_number' column specified multiple times..?

Question

SQL

The query works, but when creating the view, it says "the column "car_number" is specified repeatedly"
select * from done_cars inner join works on done_cars.car_number=works.car_number where works.number=( select number from works group by number order by count(number ) desc limit 1);

Answer 1

car_number is duplicated for you - done_cars.car_number and works.car_number
when creating a view, specify explicitly from which table to take fields