An attorney is considered the official name for a lawyer in the United States. An attorney-at-law is defined as a practitioner in a court of law who is legally qualified to prosecute and defend actions in such court on the retainer of clients.
"Automotive" refers to anything related to an "Automobile". For example, a brake disc is an automotive part as it is related to or is a part of an automobile (like a car, bus, truck, etc).
A consultant is usually an expert or a professional in a specific field and has a wide area of knowledge in a specific subject. Consultants can save their clients time, increase revenue, and maintain resources.