as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
create an sql query to find the vendors with the highest ratings.
user
select name, max(rating) from vendors group by name;
assistant